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:
Open Data Preparation menu and click on Column Functions
Choose the column URL as the source.
Enter the string / as the delimiter.
Enter the names Website and Path as the resulting column names.
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
The result column documentation
To extract only part of a column value instead of splitting it.