Parsing Json

[Khanzali007]

Hi,

I am new to Alteryx. I want to convert Json file to Excel. I don't have idea to convert it.

I have attached the json file I am working with and hope someone can help me figure this out.

Thank you!

[echuong1 · Accepted solution]

Try using the JSON parse tool. Once you have the data parsed into name and values, you can continue parsing out the name and then use transpose/cross tab to get it into the format you ultimately need.

Hope this helps!