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.
Quickstart
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:
- Go to Transform > Column Functions.
- Select the Split Into Multiple Columns function.
- 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
- 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.
info
- Result Column: The result column documentation
- Extract Text: To extract only part of a column value instead of splitting it.