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.

Table of Contents

Quick Start

Let us start with the following sample data.

URL
website1.com/Alice
website2.com/Bob
website1.com/Chuck

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

  1. Open Data Preparation menu and click on Column Functions
  2. Choose the column URL as the source.
  3. Enter the string / as the delimiter.
  4. Enter the names Website and Path as the resulting column names.
  5. Click APPLY.

The data appears as shown below:

URL Website Path
website1.com/Alice website1.com Alice
website2.com/Bob website2.com Bob
website1.com/Chuck website1.com Chuck

Supported Options

The following options are supported

  • 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.

See also

Result Column

The result column documentation

Extract Text

To extract only part of a column value instead of splitting it.