Page tree

Release 9.2


Scheduled Maintenance: will be offline for maintenance at 3:00pm UTC on Tuesday March 28 for about 15 minutes.


This section describes how to unnest the values in an Array into separate columns in your dataset.


In the following example dataset, students took the same test three times, and their scores were stored in any array in the Scores column.



When the data is imported, you might have to re-type the Scores column as an array:

Transformation Name Change column data type
Parameter: Columns Scores
Parameter: New type Array

You can now unnest the Scores column data into separate columns:

Transformation Name Unnest Objects into columns
Parameter: Column Scores
Parameter: Parameter: Paths to elements [0]
Parameter: Parameter: Paths to elements [1]
Parameter: Parameter: Paths to elements [2]
Parameter: Parameter: Paths to elements [3]
Parameter: Remove elements from original true
Parameter: Include original column name true

In the above transformation:

  • Each path is specified in a separate row. 
    • The [x] syntax indicates that the path is the xth element of the array. 
    • The first element of an array is referenced using [0]
  • You can choose to delete the element from the original or not. Deleting the element can be a helpful way of debugging your transformation. If all of the elements are gone, then the transformation is complete. 
  • If you include the original column name in the output column names, you have some contextual information for the outputs.



This page has no comments.