Skip to content

Fold an array

Description

The Fold an Array activity transforms an array column into multiple rows. Each element in the array becomes a new row while retaining the values from other columns. This is useful when working with datasets where array-type columns need to be normalized for easier filtering, joining, or visualization.

Use Case
Useful in scenarios like flattening product tags, splitting multi-select values, or breaking grouped log messages into separate events.


Input

TypeDescription
DataDataset with one or more columns containing arrays.

Output

TypeDescription
Transformed DataRows expanded by array elements in the selected column.

Configuration Fields

Field NameRequiredDescription
Column NameYesThe column containing array values to be unfolded into separate rows.

Sample Input

IDArray values
1[“A”, “B”, “C”]
2[“X”, “Y”]

Sample Configuration

FieldValue
Column NameArray values

Sample Output

IDArray values
1A
1B
1C
2X
2Y