# Joining the data

## Procedure

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

   ![](https://help.qlik.com/talend/en-US/components/7.3/Resources/images/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.