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.

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.