Split Column
Description
This activity splits the values of a cell into multiple columns using a user-defined separator. The resulting columns can include the original column data if configured.
Input
Data Only
Output
Transformed Data
Configuration Fields
-
Column To Split
The column to be split. -
Separator The character or string used to split the column values.
-
Output Columns Prefix Prefix for the new columns created after splitting.
-
Include Original
When enabled, the original column is kept alongside the new columns. Otherwise, only the new columns are included.
Input Data
| category | value |
|---|---|
| Electronics|Mobiles|Computers | 10 |
| Home|Kitchen|Furniture | 20 |
| Home|Kitchen | 20 |
| Furniture|Kitchen|Electronics | 20 |
| Electronics|Mobiles|Furniture | 20 |
Sample Configuration
Output Data
| category | value | new_1 | new_2 | new_3 |
|---|---|---|---|---|
| Electronics|Mobiles|Computers | 10 | Electronics | Mobiles | Computers |
| Home|Kitchen|Furniture | 20 | Home | Kitchen | Furniture |
| Home|Kitchen | 20 | Home | Kitchen | |
| Furniture|Kitchen|Electronics | 20 | Furniture | Kitchen | Electronics |
| Electronics|Mobiles|Furniture | 20 | Electronics | Mobiles | Furniture |