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...
ptaylor's avatar
ptaylor
Employee
7 years ago

Actually, here’s a much simpler pipeline to accomplish the same. Note that both of these pipelines resolve the name conflict between the “Total” and “TotalGross” fields in the root object vs the TransactionItem objects by renaming either the child fields (first pipeline) or the root fields (second pipeline).
JSON flatten 2_2018_11_28.slp (13.9 KB)

arvindnsn's avatar
arvindnsn
Contributor
7 years ago

Thank you for the Solution. That works and helps.