Json to a Excel Table.

[rohit782192]

Hi,

I have a Json File i want to Convert Json to a Excel Table format.

where Tags are the Header and Sub Header and Values are keys .

[SGolnik]

Have you tried using the json parse tool? https://help.alteryx.com/current/en/designer/tools/developer/json-parse-tool.html 

[Raj]

Please Convert this file type to .Json and then use Json parse tool you can refer the Example attached to tool in Alteryx as well.

[rohit782192]

I tried but via Input Data tool it is not getting loaded.

[Swathi]

The format you file has isint what the tool can take so try getting it into a single line, by concatenating it

Attaching the workflow for ease ,(Leaving the rest for the transformations bit)  Please mark as solution if it helps

[SGolnik]

You can also read in XML from the .txt using the input tool as a .csv file with a delimeter of \0.

[apathetichell]

The problem is that Alteryx's input data is inexplicably awful for JSON natively.

Having said that - just bring this in as plain text with the \0 delimiter as @SGolnik points out. Use a summarize tool in concat mode (with \n or \0 as your option) - and then use json parse on that concatenated value.

The json parse tool is awesome.