Reading input and lookup data and creating joins on related columns - 7.1

Data Stewardship

author
Talend Documentation Team
EnrichVersion
Cloud
7.1
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Data Stewardship components
Data Quality and Preparation > Third-party systems > Data Stewardship components
Design and Development > Third-party systems > Data Stewardship components
EnrichPlatform
Talend Data Stewardship
Talend Studio

The two tFileInputDelimited components read from the csv files input data about international customers and lookup data about stewards' emails and countries. The tMap component combines rows from the country columns in the input and lookup data.

If there are customers whose countries do not match any record in the lookup file, the Job writes the tasks in the campaign and leaves them unassigned.

Procedure

  1. Double-click each of the tFileInputDelimited components to open its Basic settings view.
  2. Define the schema which corresponds to the input file structure in the first component and the schema of the lookup file in the second component.
  3. Set the row and field separators in the corresponding fields and the header and footer, if any.
  4. Double-click tMap to open its editor.
  5. Map the input data flow to the output flow in the loadtasks table.
    For further information about tMap, see tMap Standard properties.
  6. To create the join to the lookup data, drop the country column from the main flow onto the same column of the lookup flow.
  7. Map the steward column from the lookup flow to the same column in the loadtasks table.
  8. Click OK to close the editor.