Hey Mike,

You *SHOULD* be able to do this with UpdateRecord by adding a property with the 
name /addresses[*]/full
and then a value of `concat(../street, ' ', ../city, ' ', ../state)` and that 
should generate an output like:

"addresses": [
  { "street": "12345 Main St", "city": "Springfield": "state", "VA", "full": 
"12345 Main St Springfield VA" }
]

But I tested that to make sure that it worked before responding. And... 
unfortunately it didn't work :( At least with an inferred schema.
So I tracked down what was going on and filed a Jira [1]. I did put up a PR for 
it. So please do check it out if you get a chance.

Thanks!
-Mark

[1] https://issues.apache.org/jira/browse/NIFI-6691

On Sep 18, 2019, at 7:15 AM, Mike Thomsen 
<[email protected]<mailto:[email protected]>> wrote:

If you have an array that looks like this:

"addresses": [
 { "street": "12345 Main St", "city": "Springfield", "state": "VA" }
]

(With a dozen more addresses for the sake of argument)

Is it possible to do something like this:

concat(/addresses/street, ' ', /addresses/city, ' ', /addresses/state)

With the end goal being that the concat is really run on each object within
the addresses array and the result set is an array of concatenated objects?

Thanks,

Mike

Reply via email to