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 .
Have you tried using the json parse tool? https://help.alteryx.com/current/en/designer/tools/developer/json-parse-tool.html
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.
I tried but via Input Data tool it is not getting loaded.
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
You can also read in XML from the .txt using the input tool as a .csv file with a delimeter of \0.
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.
