Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

JSON Parse

synergy825
8 - Asteroid

Hi,

 

I am very new to Alteryx, and I was wondering how does the JSON Parse tool work.  Attached is the workbook with the JSON file, and I want to be able to pull its fields and values.  Also, is it possible to convert it into a CSV format?  I am not sure how to utilize this in a workflow.  Any help would be greatly appreciated!  Thanks!

10 REPLIES 10
Felipe_Ribeir0
16 - Nebula

Hi @synergy825 

 

\0 means "no delimiter". With this configuration, the input tool will not try to parse the input.

 

About the UTF-8, i just used this one because it is usually a good choice (it fits almost any character that we normally see). You can just change for the default code page that you use and it probably will work too.

 

 

Labels