Joining the data - 7.3

Processing (Integration)
Version
7.3
Language
English
Product
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
Module
Talend Studio
Content
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)
Last publication date
2024-02-21

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.