How to Implement full outer join using tJoin?

[Anonymous]

Hi,

I am trying to implement full outer join using t Join but didn't got expected result,

Thanks

[Anonymous · Accepted solution]

Hello,

Could you please have a look at this KB article about:https://community.talend.com/t5/Architecture-Best-Practices-and/How-to-do-a-full-outer-join-in-a-Tal... to see if it helps?

Best regards

Sabrina

[fdenis]

you can do it if you did not set link and set return All Match

[Anonymous]

I am new to this tool, could you please elaborate the steps to be followed.

[manodwhb]

@k_pujari,they have given step by step in below link.

https://community.talend.com/t5/Architecture-Best-Practices-and/How-to-do-a-full-outer-join-in-a-Tal...

[Anonymous]

@manodwhb : i have gone through it, i want a solution using tJoin, in the given solution they used tMap.

[manodwhb]

@k_pujari,you have two tMaps right ,instead of tMap's place the tJoin's with left outer join will work the same flow.

[manodwhb]

@k_pujari,please accept the solution,which one is helped you. 

[fdenis]

use tmap in place of tJoin.

[fdenis]

if you want to use tJoin add an id (all Id=1) to all your tables.
then match on this id 1=1 so you are going to build a full match