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 single column called "Data".
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac10_Data.png)
We'll use the Split column step to split this single column into three different columns using the delimiter of a dash mark "-". The output data will look like this:
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac12_Step.png)
Custom settings
First, in the dropdown select from menu, choose which column to split into one or more.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac18_Which%20column_.png)
Next, decide if you'd like your data split into new columns or rows by clicking into the linked dropdown menu columns.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac1e_Columns%20vs%20Rows.png)
You can separate a column's value based on any delimiter by typing into the section type value... whether it be a comma, semi-colon, dash, space, number, letter, or special character. In our screenshot examples, the "Data" column is split into three columns based on a dash mark -.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac12_Step.png)
Helpful tips
- If you'd like to join a dataset using this step to another one based on the step's newly-generated column output and choose to separate values by a comma, be sure to include the space after the comma in order for values to start with the letter or number. For example, splitting apart a column of orders like "shirt, pants, hat" by the comma without a space — like (,) versus (, ) — will create the output of rows "shirt", " pants", and " hat".