We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

JSON Parse

synergy825
8 - Asteroid
‎10-13-2022 01:37 PM

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!

JSON Test.yxmd
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

10 REPLIES 10
Felipe_Ribeir0
16 - Nebula
‎10-18-2022 05:06 PM

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.

 

 

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All