Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.



For many recipes, the first step is to split data from a single column into multiple columns. This section describes the various methods that can be used for splitting a single column into one or more columns, based on character- or pattern-matching or position within the column's values.


Tip: When this transform appears in a suggestion card, the maximum number of suggested columns to split is 250, which may prevent the browser from crashing. If your dataset requires additional column splits, you can edit the transformation and increase the maximum number of splits. Avoid creating datasets that are wider than 1000 columns.

Split by Delimiter

When data is initially imported into 

D s product
, data in each row may be split on a single delimiter. In the following example, you can see that the tab key is a single clear delimiter: