Description
The Fold Multiple Columns activity transforms multiple column values into a key-value format. It converts wide-form data (multiple columns) into long-form data (rows), where each selected column becomes a row entry with two new fields: one for the original column name (label) and another for the value.
Use Case
This is useful when reshaping data for charting, normalization, or when preparing data for machine learning models that expect long-form inputs.
Type | Description |
---|
Data | Dataset with multiple columns to fold. |
Output
Type | Description |
---|
Transformed Data | Dataset with folded columns converted into row-based values. |
Configuration Fields
Field Name | Required | Description |
---|
UseRegex | No | Enable to match columns dynamically using a regular expression. |
Pattern To Match | Conditional | Regex pattern to match column names. Visible only if UseRegex is enabled. |
Columns To Fold | Yes (if UseRegex is disabled) | List of specific columns to fold. |
Folded Column | Yes | Name of the new column that stores the original column names (labels). |
Values Column | Yes | Name of the new column that stores the values from the folded columns. |
ID | Name | Q1 | Q2 | Q3 |
---|
1 | Alice | Yes | No | Yes |
2 | Bob | No | Yes | No |
Sample Configuration
Field | Value |
---|
Columns To Fold | Q1, Q2, Q3 |
Folded Column | Question |
Values Column | Response |
Sample Output
ID | Name | Question | Response |
---|
1 | Alice | Q1 | Yes |
1 | Alice | Q2 | No |
1 | Alice | Q3 | Yes |
2 | Bob | Q1 | No |
2 | Bob | Q2 | Yes |
2 | Bob | Q3 | No |