Thanks Bryan, That got the job done!
Regards, Paul On Wed, Nov 29, 2017 at 9:09 PM Bryan Bende <[email protected]> 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 <[email protected]> > 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 >
