Configure data structure transformation - 6.5

Synonym index

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Data Quality components > Standardization components > Synonym index components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Synonym index components
Design and Development > Third-party systems > Data Quality components > Standardization components > Synonym index components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tMap to open the map editor.
  2. 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.
  3. 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).
  4. In the Expression field of the Nicknames column on the output side (right), type in DqStringHandling.safeConcat('|',).
  5. 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).
  6. Click OK to validate these changes and accept the propagation prompted by the dialog box that pops up.