Parsing addresses against QAS - 7.1

Address standardization

author
Talend Documentation Team
EnrichVersion
7.1
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 > 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
EnrichPlatform
Talend Studio

About this task

You can run the Parsing addresses against reference data in the Cloud Job using the QAS Pro OnDemand service and verifiy the accuracy and completeness of addresses.

Procedure

  1. In the tFixedFlowInput Basic settings, create the schema through the Edit Schema button.
    In the open dialog box, click the [+] button and add one column that will hold the information in the input address, in this example: address.
  2. Click OK.
    An address column is created in the Inline Table.
  3. In the Inline Table table, enter the address data you want to analyze, for example:
    "1 nonsense st, nowhereville, SC,11111"
    "14 elmwood,rome,ga,30161"
    "300 n quincy pl, charlestown,MA,02129"
    "reba st,pelion,SC,29123"
    "1445 montebello st,montebello,90640"
    "43400 gadsden ave,lancaster,ca,93534"
    "po box 123,san francisco,ca,94104"
    "43400 gadsden ave apt 3,lancaster,ca,93534"
    
  4. In the basic settings of tAddressRowCloud, select QAS from the Address Provider list.
  5. From the Country list, select the country corresponding to your input addresses, United States in this example.
  6. In the QAS OnDemand username and password fields, enter respectively your username and password you can find in the license provided by QAS.
  7. In the Mapping table, click the [+] button to add a line and then select Address.
    The component will map the values of this field to the input column you set in this table.
  8. Leave the parameters in the Advanced settings view unchanged.
  9. Save your Job and press F6 to execute it.
    The tAddressRowCloud component uploads data to the cloud, validates and retrieves the corrected data and writes the result in the output file.
  10. Right-click the output component and select Data Viewer to display the formatted address data.
    tAddressRowCloud validates input address data against QAS Pro OnDemand and writes formatted addresses in the output file.
    The VerificationLevel output column provides you with a verification status of the processed addresses. For further information, see Address verification levels in tAddressRowCloud.