Scenario 1: Checking and correcting the postal code, city and street - 6.1

Talend Components Reference Guide

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 checks and corrects the addresses and postal codes from a file.

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

  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 click OK to close the dialog box.

    The component is displayed in the workspace. The file used in this scenario is called SampleAddresses. It contains address data that comes with a country code. The street and house number are saved together in the street field, while postal code and city are respectively saved in separate fields.

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

  4. Connect tMap with tUniservRTPost first.

    Accept the schema from tUniservRTPost 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 and on the right is the schema of tUniservRTPost. At the bottom is displayed the Schema Editor, where you can find the attributes of the individual columns and edit them.