Split columns
Summary
This operation is used for splitting data columns.
E.g. Making three columns out of one column.
Configuration
Input settings of existing table
Name | Value | Opt. | Description | Example |
|---|---|---|---|---|
Mapping | System.Object | opt. | - | - |
Settings
Name | Value | Opt. | Description | Example |
|---|---|---|---|---|
Separator | System.String
| - | This character separates the individual data columns | - |
Remarks
This operation is often used to separate data for searches, or for output data.
Want to learn more?
Examples
Example: Split one column into six columns
Situation | The content of column A should be separated into three different columns:
|
|---|---|
Settings |
|
Result |
Of course these columns are not in the right format and have the wrong column names. Use Format columns 2.0 to correct the format:
Use the Rename, reorder and delete columns 2.0 operator to rename your columns:
The Result of both operators looks like this:
|
Project File | - |
Example: Split one column into three columns
Situation | The content of column A Identifier should be separated into three different columns:
|
|---|---|
Settings |
|
Result |  |
Project-File | - |
Troubleshooting
Nothing known up to now.