Configuring the input component - 7.3

Loqate address standardization

EnrichVersion
Cloud
7.3
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
EnrichPlatform
Talend Studio
task
Data Governance > Third-party systems > Data Quality components > Standardization components > Address standardization components > Loqate address standardization components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Address standardization components > Loqate address standardization components
Design and Development > Third-party systems > Data Quality components > Standardization components > Address standardization components > Loqate address standardization components

Procedure

  1. Double-click tFixedFlowInput to open its Basic settings view in the Component tab.
  2. Create the schema through the Edit Schema button.
    In the open dialog box, click the plus button and add the columns that will hold the information in the input address, in this example: address_input, COUNTRY and data_description.
  3. Click OK.
  4. In the Number of rows field, set the number of rows as 1.
  5. In the Mode area, select the Use Inline Content (delimited file) option, and set the row and field separators in the corresponding fields.
  6. In the Content table, enter the address data you want to analyze, for example:
    Boise Town Square  421 N Cole Rd   83704,,wrong data
    Boise Capitol 280 S Capitol Blvd  83702,us,both address coutry correct
    Federal Way  3563 South Federal Way    83705,US, both correct
    Salmon Creek In-Store (ALB) 14300 NE 20th Ave Ste.B-101  Vancouver WA 98686,US,both correct
    Battle Ground   2500 West Main Street,,no country;address miss(Battle Ground WA 98604 )
    Battle Ground   2500 West abcd Street,,no country address changed
    south southjkjkjkjkjkj,,wrong data