In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Reading Nested JSON

nazrin_guliyeva
7 - Meteor

Hi everyone,

 

I have double nested JSON data that I would like to bring in table form:

nazring_0-1615286423132.png

Is there any recommendations on how I can unnest nested_field as well and bring in a format like this:

nazring_1-1615286730890.png

 

 

 

2 REPLIES 2
pedrodrfaria
13 - Pulsar

Hi @nazrin_guliyeva 

 

Are you able to share the dataset as a file?

 

You are probably looking at the JSON Parse tool and some data cleaning logic afterwards for this.

 

Pedro.

nazrin_guliyeva
7 - Meteor

JSON Parse tool unfortunately was not helping. Solved the issue with Regex tool and then Json Parse. Thank you!

Labels
Top Solution Authors