topic Re: Restrict Incoming records by conditions in tmap Expression filter in Talend Studio https://community.qlik.com/t5/Talend-Studio/Restrict-Incoming-records-by-conditions-in-tmap-Expression/m-p/2318762#M89079 <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1213.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LxSK.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152261i6128550BBD4DB131/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LxSK.png" alt="0683p000009LxSK.png" /></span></SPAN></P> Wed, 09 May 2018 16:23:00 GMT Karuetl 2018-05-09T16:23:00Z Restrict Incoming records by conditions in tmap Expression filter https://community.qlik.com/t5/Talend-Studio/Restrict-Incoming-records-by-conditions-in-tmap-Expression/m-p/2318758#M89075 <P>I want to ignore those rows having "UNITED STATES" and pass through those are not "UNITED STATES"</P> <P>&nbsp;</P> <P>When i tried using tmap with condition as below , i&nbsp; still see values having UNITED STATES&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1213.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LxRb.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144114i00620D3B0D37EED1/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LxRb.png" alt="0683p000009LxRb.png" /></span></SPAN></P> Wed, 09 May 2018 15:59:37 GMT https://community.qlik.com/t5/Talend-Studio/Restrict-Incoming-records-by-conditions-in-tmap-Expression/m-p/2318758#M89075 Karuetl 2018-05-09T15:59:37Z Re: Restrict Incoming records by conditions in tmap Expression filter https://community.qlik.com/t5/Talend-Studio/Restrict-Incoming-records-by-conditions-in-tmap-Expression/m-p/2318759#M89076 <P>Hi,</P> <P>&nbsp;</P> <P>Please try below.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="countryFilter.PNG" style="width: 608px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LxVh.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/147099iAF377303DFFC9D5B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LxVh.png" alt="0683p000009LxVh.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="countryFilter1.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LxVm.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138896i56D7D9CC2418ED96/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LxVm.png" alt="0683p000009LxVm.png" /></span></SPAN></P> <P>Regards,</P> Wed, 09 May 2018 16:11:31 GMT https://community.qlik.com/t5/Talend-Studio/Restrict-Incoming-records-by-conditions-in-tmap-Expression/m-p/2318759#M89076 vboppudi 2018-05-09T16:11:31Z Re: Restrict Incoming records by conditions in tmap Expression filter https://community.qlik.com/t5/Talend-Studio/Restrict-Incoming-records-by-conditions-in-tmap-Expression/m-p/2318760#M89077 <P>I tried out still not working&nbsp;</P> <P>&nbsp;</P> <P>below is my entire flow&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1213.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LxA7.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150699iE8E40785E142A244/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LxA7.png" alt="0683p000009LxA7.png" /></span></SPAN></P> <P>&nbsp;</P> Wed, 09 May 2018 16:19:43 GMT https://community.qlik.com/t5/Talend-Studio/Restrict-Incoming-records-by-conditions-in-tmap-Expression/m-p/2318760#M89077 Karuetl 2018-05-09T16:19:43Z Re: Restrict Incoming records by conditions in tmap Expression filter https://community.qlik.com/t5/Talend-Studio/Restrict-Incoming-records-by-conditions-in-tmap-Expression/m-p/2318761#M89078 <P>Please post tMap configuration.</P><P>&nbsp;</P><P>Regards,</P> Wed, 09 May 2018 16:21:52 GMT https://community.qlik.com/t5/Talend-Studio/Restrict-Incoming-records-by-conditions-in-tmap-Expression/m-p/2318761#M89078 vboppudi 2018-05-09T16:21:52Z Re: Restrict Incoming records by conditions in tmap Expression filter https://community.qlik.com/t5/Talend-Studio/Restrict-Incoming-records-by-conditions-in-tmap-Expression/m-p/2318762#M89079 <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1213.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LxSK.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152261i6128550BBD4DB131/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LxSK.png" alt="0683p000009LxSK.png" /></span></SPAN></P> Wed, 09 May 2018 16:23:00 GMT https://community.qlik.com/t5/Talend-Studio/Restrict-Incoming-records-by-conditions-in-tmap-Expression/m-p/2318762#M89079 Karuetl 2018-05-09T16:23:00Z Re: Restrict Incoming records by conditions in tmap Expression filter https://community.qlik.com/t5/Talend-Studio/Restrict-Incoming-records-by-conditions-in-tmap-Expression/m-p/2318763#M89080 <P>HI,</P><P>please check source data. if you have any spaces for country name and trim before comparing.</P><P>&nbsp;</P><P>Regards,</P> Wed, 09 May 2018 16:25:56 GMT https://community.qlik.com/t5/Talend-Studio/Restrict-Incoming-records-by-conditions-in-tmap-Expression/m-p/2318763#M89080 vboppudi 2018-05-09T16:25:56Z