Overview

The processor concatenates the values of two string columns into one single string. 

Input

The processor can operate on any dataset. Datetimes and Numerical values are transformed into strings.

Configuration

Note that there is no generated space between the concatenated strings. Simple concatenation can be done by inserting the space character in the "INFIX" field.

Output

The input table is forwarded to the output, along with the additional newly created column containing the concatenated strings.

Example

In this example, we use the books dataset attached bellow. The title A of a book is concatenated to the author B to generate a new column containing strings in the format "A by B".

Workflow

Example input

Example Configuration

Note that whitespaces are not generated while concatenating the two strings. The used infix here is ␣by␣

Result

The processor Column Selection is used to extract the newly generated column:

Related Articles

Add Constant String Processor