Merging segments in json

[manohar]

Hi there, I have input of a snap coming in as

but want to have it as and “order-line” renamed as “order-lines”

Basically grouping the “data” segment.

I have tried Join, Group by Field, Mapper snaps but nothing worked. surely I am not doing right.

Any pointers on how to achieve it?

Thanks
Manohar
jsoninput.json (106.8 KB)

[bojanvelevski]

You need a lot of transformations there, so I would suggest using additional Mapper with a mapping root that goes down to order-lines and manually map the output. Here, I updated the pipeline and did some of the output fields:

Structuring Data_2022_11_11.slp (127.8 KB)

[manohar]

Thank you very much @bojanvelevski. That’s something new I learned today the capability of Mapper snap without using code.