https://community.qlik.com/t5/Talend-Studio/How-to-exclude-lookup-match-rows/m-p/2259747#M41116 <P>Hi,</P> <P>&nbsp;</P> <P>tMap&nbsp;INNER JOIN do this for you, select catch rejected on output and it will work as expected</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tMapReject.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M2TY.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/158273iB3D20DA37831455C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M2TY.png" alt="0683p000009M2TY.png" /></span></SPAN></P> <P>&nbsp;</P> <P>row1 (main flow - source file in your case)</P> <P>row2 - lookup</P> Tue, 12 Feb 2019 21:33:06 GMT vapukov 2019-02-12T21:33:06Z https://community.qlik.com/t5/Talend-Studio/How-to-exclude-lookup-match-rows/m-p/2259746#M41115 <P>Hi,</P><P>&nbsp;</P><P>i want to exclude lookup matched rows from output. Please see the sample data below.</P><P>&nbsp;</P><P>source file 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Lookupfile&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;targetfile</P><P>123456&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;456374&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;123456</P><P>456374&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 734541&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3154611</P><P>789654&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8745654</P><P>3154611&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;789654</P><P>&nbsp;</P><P>Can some one help me how to exclude matched rows.</P><P>&nbsp;</P><P>Thanks,</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 06:36:41 GMT https://community.qlik.com/t5/Talend-Studio/How-to-exclude-lookup-match-rows/m-p/2259746#M41115 Bharath12 2024-11-16T06:36:41Z https://community.qlik.com/t5/Talend-Studio/How-to-exclude-lookup-match-rows/m-p/2259747#M41116 <P>Hi,</P> <P>&nbsp;</P> <P>tMap&nbsp;INNER JOIN do this for you, select catch rejected on output and it will work as expected</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tMapReject.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M2TY.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/158273iB3D20DA37831455C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M2TY.png" alt="0683p000009M2TY.png" /></span></SPAN></P> <P>&nbsp;</P> <P>row1 (main flow - source file in your case)</P> <P>row2 - lookup</P> Tue, 12 Feb 2019 21:33:06 GMT https://community.qlik.com/t5/Talend-Studio/How-to-exclude-lookup-match-rows/m-p/2259747#M41116 vapukov 2019-02-12T21:33:06Z https://community.qlik.com/t5/Talend-Studio/How-to-exclude-lookup-match-rows/m-p/2259748#M41117 <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Talend.JPG" style="width: 982px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M33m.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/155821i36382ECED0D8A0A2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M33m.jpg" alt="0683p000009M33m.jpg" /></span></SPAN></P> Tue, 12 Feb 2019 21:41:45 GMT https://community.qlik.com/t5/Talend-Studio/How-to-exclude-lookup-match-rows/m-p/2259748#M41117 akumar2301 2019-02-12T21:41:45Z