Articles on: Transforms

Split column

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

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

Was this article helpful?

Share your feedback

Cancel

Thank you!