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.
Type | Description |
---|
Data | Dataset with one or more columns containing arrays. |
Output
Type | Description |
---|
Transformed Data | Rows expanded by array elements in the selected column. |
Configuration Fields
Field Name | Required | Description |
---|
Column Name | Yes | The column containing array values to be unfolded into separate rows. |
ID | Array values |
---|
1 | [“A”, “B”, “C”] |
2 | [“X”, “Y”] |
Sample Configuration
Field | Value |
---|
Column Name | Array values |
Sample Output