Configuring the components

QAS address standardization

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Data Services Platform
Talend Data Fabric
Talend MDM Platform
Talend Data Management Platform
Talend Big Data Platform
Talend Real-Time Big Data Platform
task
Design and Development > Third-party systems > Data Quality components > Standardization components > Address standardization components > QAS address standardization components
Data Governance > Third-party systems > Data Quality components > Standardization components > Address standardization components > QAS address standardization components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Address standardization components > QAS address standardization components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click the tMap component to open the Map Editor and concatenate the Address, Postal, and City fields from the incoming data flow in one output column: Edit_Address.
    When done, click OK to close the Map Editor and propagate the changes to the next component.
  2. Double-click the tQASAddressRow component to display its Basic settings and define its properties.
  3. In the QAS WSDL url field, enter the URL for the QuickAdress XML document (provided by Experian QAS).
  4. On the Country list, select the country corresponding to your input addresses, France in this example.
  5. If needed, click Edit schema to view the input and output data flow. The output schema should include the Edit_Address column that hold the Address, Postal, and City initial input columns.
    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. On the Column to analyze list, select Edit_Address.
  7. Double-click the tFilterRow component to display its Basic settings view and define its properties.
  8. In the Conditions area, click the plus button to add one condition to the output flow and in the corresponding table cells:
    -select the input column you want to operate on,
    -select the needed function on the list,
    -select the operator to bind the input column with the value,
    -type in between the quotes the address value to be filtered.
    In this example, we want to exclude the addresses which status is equal to None.
  9. Double-click the tLogRow component to display its Basic settings and define its properties.
    In this example, and for clarity purposes, we want the result to display on the console in a separate key/value tabular list for each row.