JSON output to a table

[SShenoy007]

Hello all, 

I am new to Alteryx and need help to parse a Json output to a excel workbook or CSVfile

Any help will be highly appreciated. Attached is the Json Input file.

Thanks

Subodh

[AbhilashR]

Hi @SShenoy007, are you looking to clean up your output file in a tabular format in excel? If yes, could you show us what it would look like, after which it would be easy to suggest steps of replicating it in Alteryx.

[Jonathan-Sherman · Accepted solution]

Hi @SShenoy007,

I think this is what you're trying to achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[SShenoy007]

Thanks Jonathan-Sherman,

Thats exactly  i wanted.

Subodh