https://community.qlik.com/t5/Talend-Studio/Using-tMap-to-join-on-multiple-columns/m-p/2301104#M73254 <P>Hi,<BR />I have a very simple problem, but I haven't found an obvious solution.<BR />I have a two table, A and B. Table A has field id. Table B has fields id1, id2 and id3. I need to filter A when it matches either id1, id2 and id3.<BR />I have tried to add this as a filtering condition to either the main or the lookup table, and it is not working - empty result.<BR />I am clearly missing something obvious.<BR />Any suggestion?<BR />Thanks.</P> Wed, 14 Dec 2016 14:08:10 GMT Anonymous 2016-12-14T14:08:10Z https://community.qlik.com/t5/Talend-Studio/Using-tMap-to-join-on-multiple-columns/m-p/2301104#M73254 <P>Hi,<BR />I have a very simple problem, but I haven't found an obvious solution.<BR />I have a two table, A and B. Table A has field id. Table B has fields id1, id2 and id3. I need to filter A when it matches either id1, id2 and id3.<BR />I have tried to add this as a filtering condition to either the main or the lookup table, and it is not working - empty result.<BR />I am clearly missing something obvious.<BR />Any suggestion?<BR />Thanks.</P> Wed, 14 Dec 2016 14:08:10 GMT https://community.qlik.com/t5/Talend-Studio/Using-tMap-to-join-on-multiple-columns/m-p/2301104#M73254 Anonymous 2016-12-14T14:08:10Z https://community.qlik.com/t5/Talend-Studio/Using-tMap-to-join-on-multiple-columns/m-p/2301105#M73255 Hi <BR />you can do it using 3 subjobs, and joint using a tmap <BR />A.id = B.id1 =&gt; put result in tmp.csv <BR />A.id = B.id2 =&gt; put result in tmp.csv <BR />A.id = B.id3 =&gt; put result in tmp.csv <BR />At the end, remove dublicate in tmp.csv <BR /> <BR />wcfsmart Wed, 14 Dec 2016 16:33:22 GMT https://community.qlik.com/t5/Talend-Studio/Using-tMap-to-join-on-multiple-columns/m-p/2301105#M73255 wcfsmart 2016-12-14T16:33:22Z