I'm looking to parse the attached JSON file into Excel (csv) can any one help me to do that?
Note the source file I take it from here: https://pastebin.com/Shggpn04
Attached is the workflow. You can then Parse out the first column as necessary. I hope this helps.
Seth
I attached a sample building a table of the most top level data.
Basically the same as @smoskowitz but picking a set of fields and converting to a table.
What you can do is select any additional fields and join these back together.
Hopefully enough for you to get started with
I'm not sure if Alteryx is able to handle JSON files. I think your best work around is the look for another solution to convert it to a regular CSV -- i.e. python.
But then again, advanced members of the Alteryx community are welcomed to correct me.
It is easy to handle JSON with the JSON Parse tool. Look for it in the Developer tab and has some examples included om how to use. If you have any issues using it -- let me know.
Read it in as json file with the input tool and then use the json parse.
Alteryx can indeed handle JSON with the JSON parse too.
@dantvli wrote: I'm not sure if Alteryx is able to handle JSON files. I think your best work around is the look for another solution to convert it to a regular CSV -- i.e. python.But then again, advanced members of the Alteryx community are welcomed to correct me.
