https://community.qlik.com/t5/Talend-Studio/Tmap-Join-with-expression-Key/m-p/2354346#M120333 This is the tMap Tue, 27 Dec 2011 13:17:23 GMT Anonymous 2011-12-27T13:17:23Z https://community.qlik.com/t5/Talend-Studio/Tmap-Join-with-expression-Key/m-p/2354344#M120331 I would like an outer join with ToracleInput and tMap. <BR />My relation is like <BR />table1.CODE == LEFT(table.NAME,3) <BR />IF i put this on expression filter i have only the matched rows... <BR />How can i do to have also the complete set for table1 ?? <BR />Regards Sat, 16 Nov 2024 12:29:17 GMT https://community.qlik.com/t5/Talend-Studio/Tmap-Join-with-expression-Key/m-p/2354344#M120331 Anonymous 2024-11-16T12:29:17Z https://community.qlik.com/t5/Talend-Studio/Tmap-Join-with-expression-Key/m-p/2354345#M120332 Hi<BR />Could you show me the screenshot of tMap?<BR />Best regards!<BR />Pedro Tue, 27 Dec 2011 10:06:55 GMT https://community.qlik.com/t5/Talend-Studio/Tmap-Join-with-expression-Key/m-p/2354345#M120332 Anonymous 2011-12-27T10:06:55Z https://community.qlik.com/t5/Talend-Studio/Tmap-Join-with-expression-Key/m-p/2354346#M120333 This is the tMap Tue, 27 Dec 2011 13:17:23 GMT https://community.qlik.com/t5/Talend-Studio/Tmap-Join-with-expression-Key/m-p/2354346#M120333 Anonymous 2011-12-27T13:17:23Z https://community.qlik.com/t5/Talend-Studio/Tmap-Join-with-expression-Key/m-p/2354347#M120334 Hi<BR />You may add a tJavaRow between tOracleInput and tMap in row5.<BR /><PRE>output_row.SLS_TERR_CODE=StringHandleing.LEFT(input_row.SLS_TERR_CODE,3);</PRE><BR />Then set tMap as the following image.<BR />Regards!<BR />Pedro Wed, 28 Dec 2011 02:33:08 GMT https://community.qlik.com/t5/Talend-Studio/Tmap-Join-with-expression-Key/m-p/2354347#M120334 Anonymous 2011-12-28T02:33:08Z