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
Twelve 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!

View solution in original post


All Replies
Twelve 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!

View solution in original post

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.

 

Twelve 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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog