topic Re: How to Implement full outer join using tJoin? in Talend Studio

How to Implement full outer join using tJoin?

Anonymous — Wed, 26 Sep 2018 08:05:12 GMT

Hi,

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

Thanks

Anonymous — Wed, 26 Sep 2018 08:12:58 GMT

Hello,

Best regards

Sabrina

fdenis — Wed, 26 Sep 2018 08:52:05 GMT

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

Anonymous — Wed, 26 Sep 2018 09:14:43 GMT

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

manodwhb — Wed, 26 Sep 2018 09:16:47 GMT

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

Anonymous — Wed, 26 Sep 2018 09:20:13 GMT

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

manodwhb — Wed, 26 Sep 2018 09:25:35 GMT

@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 — Wed, 26 Sep 2018 09:31:03 GMT

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

fdenis — Wed, 26 Sep 2018 09:38:02 GMT

use tmap in place of tJoin.

fdenis — Wed, 26 Sep 2018 09:41:15 GMT

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

Anonymous — Wed, 26 Sep 2018 09:42:25 GMT

@manodwhb : tJoin supports only inner join how could we get left outer join from it.

manodwhb — Wed, 26 Sep 2018 09:55:44 GMT

@k_pujari,tJoin by default it will support leftout join

Anonymous — Wed, 26 Sep 2018 09:57:58 GMT

Thanks Manohar!!