Doing an inner join using a tMap component

Six Stars

Doing an inner join using a tMap component

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.


Accepted Solutions
Eleven Stars

Re: Doing an inner join using a tMap component

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!


All Replies
Eleven Stars

Re: Doing an inner join using a tMap component

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Six Stars

Re: Doing an inner join using a tMap component

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

Six Stars

Re: Doing an inner join using a tMap component

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

 

Eleven Stars

Re: Doing an inner join using a tMap component

the last solution is for me the best one!

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Six Stars

Re: Doing an inner join using a tMap component

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