Configuring the output component and executing the Job - 7.2

Address standardization

Version
7.2
Language
English (United States)
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Data Quality components > Standardization components > Address standardization components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Address standardization components
Design and Development > Third-party systems > Data Quality components > Standardization components > Address standardization components

Procedure

  1. Double-click the tFileOutputExcel component to display the Basic settings view and define the component properties.
  2. Set the destination file name as well as the sheet name and then select the Define all columns auto size check box.
  3. Save your Job and press F6 to execute it.
    The tBatchAddressRowCloud component parses addresses using batch processing. It corrects addresses using the online batch service of Loqate and writes the result in batch files on the Loqate server.
  4. Right-click the output component and select Data Viewer to display the formatted address data.
    tBatchAddressRowCloud matches input address data against the Loqate repository.
    The STATUS output column returns the OK status for all address rows. This means that the verification process of all address rows could be completed successfully by the component. For further information about process status, see tloqateaddressrow-tloqateaddressrow_process-status-in-tloqateaddressrow_standard_component_enterprise_the-tloqat_topic.html.
    The VerificationLevel output column provides you with a verification levels defined by Talend . For further information, see Address verification levels in tAddressRowCloud.
    The AddressVerificationCode output column returns a verification code for each of the processed address rows.
    For further information about what values this code is made up of and the implications of each segment, see tloqateaddressrow-tloqateaddressrow_address-verification-codes-in-tloqateaddressrow_standard_component_enterprise_the-tloqat_topic.html.