Split column

The Split column step splits a column into one or more based on a specified delimiter, such as a comma.

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.