You can unnest Array or Object values into separate rows or columns using the following transformations.

Flatten Array Values into Rows

Array values can be flattened into individual values in separate rows. 

Unnest Array Values into New Columns

You can also split out the individual values in an array into separate columns.

Flatten and Unnest Together

The following example illustrates how flatten and unnest can be used together to reshape your data.

Unnest Object Values into New Columns

This example shows how you can unnest Object data into separate columns. The example contains vehicle identifiers, and the Properties column contains key-value pairs describing characteristics of each vehicle.

Extract a Set of Values

This example shows how to extract values (for example, hashtag values) from a column and convert them into a column of arrays.

Nesting Data

 provides multiple methods for transforming tabular data into nested Arrays and Objects. For more information on nesting data, see Nest Your Data.