https://community.qlik.com/t5/Talend-Studio/How-to-get-Right-outer-join/m-p/2347949#M115138 Hi <BR />Only need to change row1 as lookup table and row2 as main table, to do: right click on row2 and select 'set this connection as main' option, and then do the left outer join. <BR />Best regards <BR />Shong Thu, 15 Sep 2011 10:58:10 GMT Anonymous 2011-09-15T10:58:10Z https://community.qlik.com/t5/Talend-Studio/How-to-get-Right-outer-join/m-p/2347948#M115137 Hi all,<BR /> I am a beginner in Talend OS. I am trying to get a right outer join using tMap. I am able to get the inner and left outer joins but right outer. Kindly tell how to get the right outer. FYI, I am attaching the screenshots of the design. Thanks in advance. Sat, 16 Nov 2024 12:41:05 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-Right-outer-join/m-p/2347948#M115137 Anonymous 2024-11-16T12:41:05Z https://community.qlik.com/t5/Talend-Studio/How-to-get-Right-outer-join/m-p/2347949#M115138 Hi <BR />Only need to change row1 as lookup table and row2 as main table, to do: right click on row2 and select 'set this connection as main' option, and then do the left outer join. <BR />Best regards <BR />Shong Thu, 15 Sep 2011 10:58:10 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-Right-outer-join/m-p/2347949#M115138 Anonymous 2011-09-15T10:58:10Z