Doing an inner join using a tMap component

[Anonymous]

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.

[fdenis · Accepted solution]

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

[Anonymous]

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

[Anonymous]

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

[fdenis]

the last solution is for me the best one!

[Anonymous]

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