Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Accepted Solutions
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 🙂
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 🙂