Read json file

[leorohit]

I have  this json file and I am struggling to read it, please help with alteryx flow to read this file

[TheOC]

Hey @leorohit 

Where is this json file from? Is it available online?

Cheers,
TheOC

[markcurry]

Hi @leorohit 

With the txt file, you can read this in as a CSV file (with \0 as the delimiter), then to use the JSON Parse tool, the data needs to be in a single record, so you can concatenate the output from the input file.  See attached, hopefully that helps you....

[mceleavey]

Hi @leorohit ,

The format of the file does not appear to be in the format in which you would receive a JSON.

To resolve this, I have used the Sum tool to concatenate the lines into a single cell:

This then creates the JSON format.

Once you have this, you can use the JSON Parse tool to create the structured data format you require:

You can then split the first column into the columns you require using the Text to Columns tool.

I hope this helps,

M.

[GosiaK]

Hi @mceleavey, I've used the approached you've suggested here and partially works. The problem is that after the summarise tool, some data is missing. I have a very long json file 381k records before summarising, so I'm expecting that concatenated text just don't fit into the field. Would you have any suggestions of how to solve this?