Converting an array to a denormalized table
This seems like it should be simple but I’m still relatively new to snaplogic and just can’t figure it out. The json coming into my Mapper snap is formatted like this:
{"record1": {"id" : "1",
...
Forum Discussion
Hello @maahutch,
You can try by using the following expression in a Mapper Snap:
$.mapValues((v,k) =>v.mapValues((v1,k1) => typeof v1 == 'object' ? v1.subject_id.map(x => {"id":v.id,"subject_id":x}): false))
Then, you just split the array with JSON Splitter with the following JSON Path:
jsonPath($,"..subject")
Attached below is the sample pipeline.
–sl-comm-array-denormalized-table_2023_06_22.slp (5.1 KB)
Please note that if you have another input structure this will not work.
Let me know if this helps you.
Best Regards,
Aleksandar.
