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

  • ,
  • ;
  • _
  • .
  • :
  • |
  • #
  • *
  • '
  • Blank

-

This character separates the individual data columns.
Default: ;

-

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.


Related topics