Concatenation Function

With the Concatenation function, several input fields can be merged into a new field.

Parameters

Template The input fields are connected according to the template. They are referenced in the form #{Name}. Fixed text elements can also be included.
Delimiter Defines the separator between the input fields. For a blank value, enter #space.

Only one of the above parameters can be used. If both parameters are empty, the input fields will be concatenated without any delimiting character.

Note: in general, Jedox Integrator automatically trims all column values; i.e., all leading and trailing blank values are removed in the result of an extract or a transform. If a column value consists only of one or multiple blank values, the result is trimmed to a single blank value. This logic avoids transformation steps on columns that are required in the context of OLAP. By using #space in the Concatenate function, you can achieve column values with one or multiple blank values in the middle.

Example

Using a Template. Inputs include:

ProductID
ProductName

Template parameter is #{ProductID} and #{ProductName}

Result:

ProductID

ProductName

Concatenation Products

771

Off-Road-100 Blue 38

771 and Off-Road-100 Blue 38

Updated June 5, 2023