Forum Discussion

arvindnsn's avatar
arvindnsn
Contributor
7 years ago

Flattening multiple array entities in JSON Object

Hello, I am trying to flatten multiple array attributes from a JSON Document. Below is the JSON document and the expected output. { “TransactionId”: 55499, “ReceiptNo”: 1123, “Location”: “x...
tstack's avatar
tstack
Former Employee
7 years ago

You could also concatenate the two arrays together and then use a single JsonSplitter on the resulting array:

$TransactionItems.concat($TransactionMedias)

The Copy/Union can also be removed then as well.

arvindnsn's avatar
arvindnsn
Contributor
7 years ago

Thanks a lot. Nice to learn to concat the arrays and manipulate them. The attached pipeline is exactly what i needed. Thanks again.