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.