Combine columns
Summary
This operator is provided for combining data columns with a set separator.
These columns can also be separated again using the operator Split columns.
Configuration
Input settings of existing table
Name | Value | Opt. | Description | Example |
|---|---|---|---|---|
Columns to be copied | System.String | - | All columns that are to be copied or renamed. | - |
Settings
Name | Value | Opt. | Description | Example |
|---|---|---|---|---|
Result column | System.String | - | Result column | - |
Mapping | System.Object | opt. | Mapping | - |
Separator |
| - | This character separates the individual data columns. | - |
Want to learn more?
Screenshot
Examples
Example: Combining two columns
Situation | This example will show you how to combine two columns: The column "Shop" and the column "turnover" which is the revenue of each Shop made every month |
|---|---|
Settings |
|
Result |
|
Project-File | - |
Troubleshooting
Nothing known up to now.