Parsing a nested JSON file into multiple tables in SQL

[vidhya]

Hi,

We have a JSON that has so many nodes, and for a pattern, the first three rows would have items for the first table, the second five rows would be for a diff table and the list goes on for like 400 tables.

Is there a way that alteryx could separate out this JSON file and map it to each table pased on a particular field?

For eg, in my case: MOITYPE?

Thanks,

[jwalder]

The JSON parser doesn't like the array ending with a null object ",}" produces an error. Remove the commas at the end of lines 30, 43 and 55 and your missing rows show up again.

[jwalder · Accepted solution]

Regarding being dynamic, the attached example uses a batch macro to dynamically write each table to its own output .csv. You should be able to modify that macro to output to a table instead.