Split column
The Split column step splits a column into one or more based on a specified delimiter, such as a comma.
Our input data below is a a list of sales orders.
We'll use the Split column step to split the "OrderDate" column into three different columns using the forward slash delimiter "/". The output data will look like this:
Pick the dataset.
Type the "Column to split" to specify the column name or index to split,
then, select from "Split into" dropdown the new columns or new rows options,
then specify the delimiter.
Split column
Input/output
Our input data below is a a list of sales orders.
We'll use the Split column step to split the "OrderDate" column into three different columns using the forward slash delimiter "/". The output data will look like this:
Settings
Pick the dataset.
Type the "Column to split" to specify the column name or index to split,
then, select from "Split into" dropdown the new columns or new rows options,
then specify the delimiter.
Updated on: 20/09/2022
Thank you!