read json file

[DFstr]

Hi there, I'm new to Alteryx and this is my very first task. I'm trying to read a JSON file and have been following an example provided within Alteryx, but it's not working for me. I also found a suggestion in the community to concatenate all entities into one field and then use the JSON Parse tool, but that approach isn't working either. Can someone help me understand how to read this type of file?

Thanks!

[Yoshiro_Fujimori · Accepted solution]

Hi @DFstr ,

I would read the .txt file by Input Data Tool with Delimiters "None"(\0) and with expand Field Length to avoid truncation.

As the file has 297,581 characters, you should set a larger Field Length.

Once the data is input, you can pass it to JSON Parse Tool.

[jrgo]

I was able to read in the file as JSON but I did need to adjust the "Code Page" option (#6) in the input tool to "Unicode UTF-8".