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 September 27, 2022