How to get lookup and main reject records in tmap inner join

[pawanw]

Hi Everyone,

I want to get inner join reject records from main table as well as lookup table

TableA  TableB
1           1
2           2
3           4

I want records with value 3 and 4 in out

[nfz11]

You need to do a full outer join which is not directly supported with a single tMap.  There are two workarounds to do it, see this article:

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