topic Joining multiple tables with multiple keys in Talend Studio

Joining multiple tables with multiple keys

Anonymous — Sat, 16 Nov 2024 05:11:20 GMT

Hi All,

I'm trying to join three tables using tMap, but I'm not getting the correct results...

Here are my input tables...

How do you join tables with diff number of primary keys?

Do they always have to be the same?

Output table

Also, when I changed the Match Model to All Rows why does it always go back to All Matched after the job run?

Any input is appreciated. Thanks!

Re: Joining multiple tables with multiple keys

Anonymous — Wed, 24 Jul 2019 02:32:30 GMT

Hi,

The reason is that you have not joined the tables. Please drop the columns to the expression area of the lookup table to create join links between two tables.

You need to also select whether the join is Left Outer or Inner based on your requirement.

I would highly recommend you to go through the details about join conditions in tMap from help.talend.com so that you will have better understanding about the component usage. There are sample scenarios also in the help document which will give you better idea about how it works.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Joining multiple tables with multiple keys

Anonymous — Wed, 24 Jul 2019 03:14:50 GMT

Got it! Thanks!