Reading Nested JSON

[nazrin_guliyeva]

Hi everyone,

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

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

[pedrodrfaria]

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 · Accepted solution]

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