read json file

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!

wgravityforms-export-2023-09-01.txt

Input

Parse

Help

Accepted answers

Yoshiro_Fujimori

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.

JsonParseTool.yxmd

All comments

Yoshiro_Fujimori

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.

JsonParseTool.yxmd

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".

this thread was really helpful

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703