Scenario: Analysis of a name line and assignment of the salutation - 6.1

Talend Components Reference Guide

English (United States)
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
Talend Studio
Data Governance
Data Quality and Preparation
Design and Development

This scenario describes a batch job that analyzes the person names in a file and assigns them a salutation.

The input file for this scenario is already saved in the Repository, so that all schema metadata is available.


Please observe that the data from the input source must all be related to the same country.

  1. In the Repository view, expand the Metadata node and the directory in which the file is saved. Then drag this file into the design workspace.

    The dialog box below appears.

  2. Select tFileInputDelimited and then click OK to close the dialog box.

    The component is displayed in the workspace. The file used in this scenario is called SampleAddresses..

  3. Drag the following components from the Palette into the design workspace: two tMap components, tUniservRTConvertName, and tFileOutputDelimited..

  4. Connect tMap with tUniservRTConvertName first.

    Accept the schema from tUniservRTConvertName by clicking Yes on the prompt window.

  5. Connect the other components via Row > Main.

  6. Double-click tMap_1 to open the schema mapping window. On the left is the structure of the input file, on the right is the schema of tUniservRTConvertName. At the bottom lies the Schema Editor, where you can find the attributes of the individual columns and edit them.

  7. Assign the columns of the input source to the respective columns of tUniservRTConvertName. For this purpose, select a column of the input source and drag it onto the appropriate column on the right side. If fields from the input file are to be passed on to the output file, like the address fields or IDs, you have to define additional fields.

  8. Click OK to close the dialog box.

  9. Double-click tUniservRTConvertName to open its Basic Settings view.

  10. Fill in the server information and specify the country-specific service.

  11. Double-click tMap_3 to open the mapping window. On the left is the schema of tUniservRTConvertName and on the right is the schema of the output file.