With this field transform function, several input fields can be merged into a new field.
Inputs
| Setting | Description |
|---|---|
| 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 an empty string, enter #empty. For a blank value, enter #space. |
Only one of the above parameters can be used. If both parameters are empty, the input fields are concatenated without any delimiting character.
For more information about how Jedox Integrator trims values automatically, and how to use #space to create blank values intentionally, see Trimming and Space Values in Integrator.
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 October 5, 2026