Split Transformation: Break Up Column Values

Split a string in a text column into two values by specifying a delimiter. To split column values into more than two parts, add multiple instances of the split transformation. For instance, you can use three split transformations to split an address into street address, city, state, and ZIP code.

1. In a transform node, select the text column in the Preview tab.
2. In the transform toolbar, click the Split button ().
3. Select the delimiter.
4. Enter the column labels for both new columns.
5. Click Apply.
   

   Tip To remove the original unsplit column, add the drop columns transformation after the split transformation.
6. To view the canvas, click the Collapse button ().
7. Save the data transform.