A transformation type of Concatenation will transform the data from the incoming file into a concatenation, where each value is joined together with the delimiter you enter. For example, you could concatenate "Last Name" and "First Name" and store it in an attribute called "Full Name".
To configure a concatenation transformation:
- Follow the steps for Mapping source object fields to data model attributes and ensure that all source fields you want to concatenate are mapped to the required data model attribute. For example, to create a concatenation for the "Full Name" attribute, map the "Full Name" data model attribute to the "First Name" and "Last Name" source fields.
- Locate the data model attribute you want transformed and click its Transform link. The Transform dialog is displayed, and it shows the source fields (source) and schema attributes (target).
- Use the Transformation type list to select Concatenation.
- Fields are shown in the order that they will be concatenated. To change the order, drag and drop them.
- In the Delimiter field, enter the character that will delimit the fields. We support only comma (,), semi-colon (;), or pipe (|) delimiters.
- Optionally, enter a string value (for example, "omitted") to replace all empty or null values during the transformation. If you leave the field blank, then any empty or null values will be displayed as empty during the concatenation.
- Click Apply.