Merging segments in json
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...
Forum Discussion
Hey @manohar,
Try the following pipeline. Keep in mind that this will work if you only have these 2 incoming objects.
Structuring Data_2022_11_10.slp (126.1 KB)
Hi @bojanvelevski , your solution works like charm…
there’s one issue though. After the Structure Snap, I get Order lines in its original format, as in the right box in below screenshot. but I need the output shown in the left box.
Example -
In
“id”: {
“@type”: “integer”,
“$”: “40114”
},
needs to be transformed to as
“id”: “40114”,
Alos, don’t need some of the nodes like “accounting-total”, “created-at”.
Then there are some like which needs to be mapped as it is
“line-num”: “00010”, to “line-num”: “00010”,
I have tried using another structure, and mapper snaps and they come out as below
Any direction in this case?
Thanks
Manohar
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)
Thank you very much @bojanvelevski. That’s something new I learned today the capability of Mapper snap without using code.
