I have json data with multiple levels of hierarchy. Some of the objects have arrays nested inside of them. Am I able to parse this in Trifacta? I’d ultimately like to join it with a csv

[Trifacta_Alumni · Accepted solution]

Hey Ellie!

Great question. Yes, this is actually very easy to do in Trifacta. To unpack a json object, you can simply click and drag over all of the values in the columns bar chart. This should prompt a suggestion to Unnest the column keys/values from the object. You can also click on the column header to generate a similar suggestion.

You can then flatten an array, which will convert all of the values of an array into their own unique row. To do this, you can click on the column header and find the suggestion to Flatten the array. I've posted a gif below to demonstrate this .

[4bc392f306592b8ab22c]

This is great. Does the flatten step duplicate all of the other columns for each new row?