Configuring the input component - 7.0

Melissa Data address standardization

author
Talend Documentation Team
EnrichVersion
7.0
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 > Melissa Data address standardization components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Address standardization components > Melissa Data address standardization components
Design and Development > Third-party systems > Data Quality components > Standardization components > Address standardization components > Melissa Data address standardization components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tFixedFlowInput to open its Basic settings view in the Component tab.
  2. Click Edit schema to make changes to the schema.
  3. Click the [+] button to add the columns that will hold the address data to your input schema.
    For this example, add:
    • input_company
    • input_address1
    • input_address2
    • input_city
    • input_state
    • input_postal
  4. Click OK.
  5. In the Number of rows field, set the number of rows as 1.
  6. In the Mode area, select the Use Inline Content (delimited file) option, and set the row and field separators in the corresponding fields.
  7. In the Content table, enter the address data you want to analyze.
    For example:
    Talend Inc.|5150 El Camino Real|Suite C-31|Los Altos||94022|
    Talend Inc.|6 Executive Circle|Suite 200|Irvine|California|92614|
    Talend Inc.|220 White Plains Road|Suite 390|Tarrytown|New York|10591|
    Talend Inc.|8 New England Executive Park|Suite 170|Burlington|Massachusetts|01803|