How to achieve Right Outer Join functionality in Talend

One Star

How to achieve Right Outer Join functionality in Talend

1. I need to join two tables Table1 and Table2.
2. Table1 is main and table2 is lookup table. 
3. Table1 key will be matched to table2 column and Output will be rows from Table2 which do not have matching data.
So, I need to implement Right join functionality for this scenario. Any help would be appreciated. Smiley Happy
Regards,
Jatin Singla
Community Manager

Re: How to achieve Right Outer Join functionality in Talend

Hi 
Make table2 as main, table1 as lookup, do an inner job and get the unmatched rows. Please take a look at this article
https://help.talend.com/pages/viewpage.action?pageId=190513450
Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: How to achieve Right Outer Join functionality in Talend

Shong, Thanks for your reply. 
But in my case table1 is an output from another tMap component which send id column data directly to another tMap component. So can't switch table2 as main input to component
Also tried to get id's in list component but new value overwrites old values and I was left with one id value instead of multiple rows.
Hope this will make it clear.
Regards,
Jatin Singla
Community Manager

Re: How to achieve Right Outer Join functionality in Talend

But in my case table1 is an output from another tMap component which send id column data directly to another tMap component. So can't switch table2 as main input to component

You can cache the output to memory first, and read the output from memory many times if neeeded later.
table1 output---main--tHashOutput
   |
onsubjobok
  |
table2--main--tMap (do inner join to get unmatched rows)
                       |
                  thashinput(read data from table1 output)
  |
onsubjobok
  |
other processing
Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business