topic Re: Doing an inner join using a tMap component in Talend Studio

Doing an inner join using a tMap component

Anonymous — Mon, 16 Jul 2018 13:16:13 GMT

Hello!
I'm having a problem using a join with the tmap component.
There is one field that i need to join on 3 different key, with the condition being if one of the 3 works i take the ID.
How can i do that?
i've tried it with the "OR" condition but it says it doesn't work with strings, and i'm now out of idea.
You can see the tmap component attached.
Thank you for reading this and helping.

Re: Doing an inner join using a tMap component

fdenis — Mon, 16 Jul 2018 13:56:13 GMT

you are looking for multiple matching possibility so you can:
use one table by matching possibility
use reload at each row and pass parameters
reate all possible matching key on the lookup table
OR
do a full match and add filter on the output
- first select "All Macth"
- remove all your lookup key
- add your filter on the output
good luck

Re: Doing an inner join using a tMap component

Anonymous — Mon, 16 Jul 2018 13:58:47 GMT

Okay i will try this thank you , i'll come back and tell if it worked

Re: Doing an inner join using a tMap component

Anonymous — Mon, 16 Jul 2018 16:16:33 GMT

Thank you it worked by using one table for each join.

Re: Doing an inner join using a tMap component

fdenis — Tue, 17 Jul 2018 07:57:40 GMT

the last solution is for me the best one!

Re: Doing an inner join using a tMap component

Anonymous — Tue, 17 Jul 2018 14:10:05 GMT

I'll try that later as my project is due very soon. But i agree that it seems better, it's just i don't have the time to check it out now.

Thanks again