how to perform full outer join using tJoin in talend

Question

I am trying to implement full outer join using tJoin component but I am not getting as expected results. Could anyone help me on this?

Screenshot of tJoin:

Screen shot of tjoin

Thanks for ur support we can implement full outer join in tjoin,we need to join left outer and right outer join after that we need combine using with tunite — Naresh AR, Oct 19 '17 at 18:28

score 1 · Answer 1 · answered Oct 04 '17 at 14:00

1

In fact Talend does not implement a full join, but you can achieve it by reading your inputs twice, performing a left and a right join for each reading, then unite the two flows using tUnite and get unique rows by tUniqRow

answered Oct 04 '17 at 14:00

54l3d

3,913
4
32
58

score 0 · Answer 2 · answered Oct 04 '17 at 07:06

0

I think tJoin is for LEFT or INNER joins.
For FULL joins you need to use a tMap.

Regards, TRF

answered Oct 04 '17 at 07:06

TRF

791
4
9

how to perform full outer join using tJoin in talend

2 Answers2