nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Riddle <paul.rid...@onyxpoint.com>
Subject Re: Combining multiple record field values into a new field
Date Thu, 30 Nov 2017 02:16:32 GMT
Thanks Bryan,

That got the job done!

Regards,
Paul

On Wed, Nov 29, 2017 at 9:09 PM Bryan Bende <bbende@gmail.com> wrote:

> Hi Paul,
>
> Can you use the “concat” function from record path?
>
> In UpdateRecord you would add a property with the key of /combined and the
> value of concat(/field1, ‘ ‘, /field2)
>
> https://nifi.apache.org/docs/nifi-docs/html/record-path-guide.html
>
> You’d have to set the Replacement Value Strategy to Record Path Value.
>
> -Bryan
>
>
> On Wed, Nov 29, 2017 at 8:41 PM Paul Riddle <paul.riddle@onyxpoint.com>
> wrote:
>
>> Hi All,
>>
>> I am trying to find a way to build a better mouse trap.  My scenario is
>> this:
>> Schema:
>> {
>>   "name": "Sample Schema",
>>   "namespace": "nifi.examples",
>>   "type": "record",
>>   "fields": [
>>     { "name": "field1", "type": "string" },
>>     { "name": "field2", "type": "string" },
>>     { "name": "field3", "type": "string" }
>>     { "name": "combined", "type": "string" }
>>   ]
>> }
>>
>> Say I have a CSV file:
>> field1,field2,field3
>> John,Mike,Lisa
>>
>> I want to use an UpdateRecord to create a new field in each record called
>> "combined" with a value of "Mike Lisa" from field2 and field3
>>
>> I am having difficulty finding a way to do that without using
>> PartitionRecord to add field values to attributes and then using expression
>> language to reference them in UpdateRecord to define the value of the
>> "/combined" field.
>>
>> Is there a way to reference the field.value variable of another field in
>> UpdateRecord and cut out PartitionRecord in this scenario?
>>
>> What I am looking for is something like ${field.value:field2()}
>> ${field.value:field3()} if something like that exists.
>>
>> Regards,
>> Paul
>>
>> --
> Sent from Gmail Mobile
>

Mime
View raw message