Configure data structure transformation

Procedure

Double-click tMap to open the map editor.
At the bottom right corner (synonyms) of the Schema editor view, click the [+] button to add two rows and name them FirstName and Nicknames. These two columns appear in the synonyms table on the right side of the map editor.
On the input side (left) of the upper part, select the FirstName column and drop it to the FirstName column on the output side (right).
In the Expression field of the Nicknames column on the output side (right), type in DqStringHandling.safeConcat('|',).
On the input side (left) of the upper part, select sequentially the columns from Nickname1 to Nickname4 and drop them to the Nicknames columns, and edit the expression in the Expression field so that it reads DqStringHandling.safeConcat('|', row1.Nickname1, row1.Nickname2, row1.Nickname3, row1.Nickname4).
Click OK to validate these changes and accept the propagation prompted by the dialog box that pops up.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!