O'Reilly logo

Talend Open Studio Cookbook by Rick Barton

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required