August 15, 2023

Joining the data – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Joining the data – Docs for ESB 6.x

Joining the data

  1. Double-click tMap to open its
    Map editor.

    use_case-ttop11.png

    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.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x