Split Column

The Split Column Step is used to divide the contents of a single column into multiple columns using a specified delimiter. It performs the opposite operation to the Join Columns Step, which combines multiple columns into one.

Key Features

• Split a Column — Divide the contents of one column into multiple columns.
• Custom Delimiter — Specify the character used to separate values, such as a comma, space, semicolon, or another character.
• Prepare Data for Processing — Separate combined values so they can be transformed, validated, or exported individually.

How to Use

1. Add the Split Column Step to the transformation.
2. Select the column you want to split.
3. Specify the delimiter used to separate the values.
4. Configure the resulting output columns as required.
5. Execute the transformation to split the data.

This step is useful when a source column contains multiple values that need to be separated into individual columns for further processing.