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
