The documentation says you use <SnapLogic_POD_Name> but does not take the time to explain what that is or provide an example; I can guess but would rather not. Kindly confirm what that value should be and/or where one would find it. Thanks.
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.
