Talend Open Studio Cookbook

Joining data using tMap

So far, we have seen how tMap can be used to transform and filter input data. But this is only a part of the tMap functionality. The tMap component is also the main component used to perform join logic between multiple input sources. This recipe demonstrates the basics of using tMap to join multiple data sources.

Getting ready

Open the job jo_cook_ch04_0070_tMapJoin.

How to do it...

1. Right-click tFileInputDelimited. Go to Row | Main and connect it to tMap_1. Change the name of the flow to order.
2. Open tMap, and you should see two input tables: customer and order.
3. Select the customerId field from the customer table and drag it to the customerId Expr. key in the order table.
4. You will see a purple key icon and a flow showing the linked ...