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.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
