Scenario: Editing addresses against QAS files and giving the verification status - 6.1

Talend Components Reference Guide

EnrichVersion
6.1
EnrichProdName
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
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

Below is a three-component Job created in Talend Studio.

This Job:

  • generates random address information,

  • uses the tQASBatchAddressRow component to analyze the output columns and display the correct formatted address along with their verification status on the console,

Complete the following to design and execute the above scenario:

Setting up the Job

  1. Drop the following components from the Palette onto the design workspace: tFixedFlowInput, tQASBatchAddressRow and tLogRow.

  2. Connect the component together using Main links.

Configuring the components

  1. Double-click tFixedFlowInput to display its Basic settings view and define the component properties.

  2. Click the [...] button next to Edit Schema to open a dialog box, and add one column: addr. Then click OK to close the dialog box.

  3. In the Mode area, select the Use Inline Table option, add three lines in the table by clicking the [+] button, and define the data for the input column, three address rows in this example.

  4. Double-click the tQASBatchAddressRow component to display its Basic settings and define the component properties.

  5. Click the [...] button next to Edit schema, if required, to view the input and output data flow. The output schema should include the addr column.

    The output schema of any of the QuickAddress components depends on the selected country in the Country list since every country has different address norms.

    Click OK to close the dialog box.

  6. Select from the Country list the country corresponding to your input addresses.

  7. Select from the Choose the address column list the address column you want to analyze, addr in this example.

  8. Click the [...] button next to the Specify the configuration file field and browse to the QAS configuration file installed locally.

  9. Double-click the tLogRow component to display its Basic settings view and select Table in the Mode area to display the Job execution result in table cells.

Executing the Job

  • Save your Job and press F6 to execute it and display the result on the console.

    In the result shown above, tQASBatchAddressRow reads input rows, corrects and formats addresses, gives the result in the ADDRESS and ZIP_CODE_CITY columns, and gives the verification status in the STATUS row. For further information on the status column, check the corresponding documentation at http://www.qas.com.