Skip to main content

Split into Multiple Columns

The Split Column task is used to split a column by a delimiter into multiple columns. This task is similar to Converting Text to Columns in Microsoft excel.


Let us start with the following sample data.


Let us assume that you want to split the column URL by the string /. Complete the folowing steps to achieve this:

  1. Go to Transform > Column Functions.
  2. Select the Split Into Multiple Columns function.
  3. Choose the column URL as the source.
  4. Enter the string / as the delimiter.
  5. Enter the names Website and Path as the resulting column names.
  6. Click APPLY.

The data appears as shown below:


Supported Options

  • Source column: The column having values to be split.
  • Delimiter: The value to split the values by. It can be a any text value including special characters, space, and numbers.
  • Number of columns: Number of new columns to create.
  • Resulting columns: The names of the new columns to be created.
  1. Result Column: The result column documentation
  2. Extract Text: To extract only part of a column value instead of splitting it.