Concatenate texts

Combines the values of the specified columns or text fragments into one text.

Appends the values from the source columns or the source values to one another one row at a time, writes the results to the target column, and overwrites any existing values there. If the target column does not exist, it is created.

The following parameters are available.

Parameter

Description

Text

Value to be linked.

Source: Source table, single-value operator, input value, or a constant.

Data type: Number, Text, Date;

Specification: Optional

Target column

Name of the column to which the linked text is written.

Source: Source table or constant.

Data type: Text

Default value: Result_1

Specification: Optional