Joining the data - 7.0

Processing (Integration)

EnrichVersion
7.0
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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Studio
task
Data Governance > Third-party systems > Processing components (Integration)
Data Quality and Preparation > Third-party systems > Processing components (Integration)
Design and Development > Third-party systems > Processing components (Integration)

Procedure

  1. Double-click tMap to open its Map editor.
    On the input side (the left side), the main flow (labeled row3 in this example) and the lookup flow (labeled row4 in this example) are presented as two tables.
    On the output side (the right side), an empty table is present.
  2. Drop all of the columns of the schema of the lookup flow into the output flow table on the right side, except the User_id column, and drop the user_id column and the url column from schema of the main flow into the same output flow table.
  3. On the left side, drop the user_id column from the main flow table into the Expr.key column in the User_id row in the lookup flow table. This makes the ID numbers of the customers the key for the join of the two input flows.
  4. In the lookup flow table, click the wrench icon to display the panel for the lookup settings and select Inner Join for the Join model property.
  5. Click Apply to validate these changes and click OK to close this editor.