https://community.qlik.com/t5/Talend-Studio/Help-with-Filter-in-tMap/m-p/2240467#M27945 <P>Hi,</P> <P>&nbsp;</P> <P>&nbsp; &nbsp;Please try the logic as shown below.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 751px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6gS.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139881i5239CBDB25208352/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M6gS.png" alt="0683p000009M6gS.png" /></span></SPAN></P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6gX.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152628i0FC96DF2A9AE0093/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M6gX.png" alt="0683p000009M6gX.png" /></span></SPAN></P> <P>&nbsp;</P> <PRE>!Relational.ISNULL(row1.data) &amp;&amp; row1.data.contains("Balance")</PRE> <P>Warm Regards,<BR />Nikhil Thampi</P> <P>Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sun, 21 Jul 2019 16:13:44 GMT Anonymous 2019-07-21T16:13:44Z https://community.qlik.com/t5/Talend-Studio/Help-with-Filter-in-tMap/m-p/2240466#M27944 <P>Need some help with filter in tMap. I have spent two days on this and unable to make out what the issue is. I have two fields in a flat file which I am reading. One is the date&nbsp; field and the other is a description.I need to filter out those records where the Description contains the word "Balance"</P> <P>&nbsp;</P> <P>I have used the below logic but the issue is that it does not filter out the records</P> <P>&nbsp;</P> <P>StringHandling.INDEX(row2.Description,"Balance") &lt; 1 &nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 16 Nov 2024 05:13:06 GMT https://community.qlik.com/t5/Talend-Studio/Help-with-Filter-in-tMap/m-p/2240466#M27944 sunbaj 2024-11-16T05:13:06Z https://community.qlik.com/t5/Talend-Studio/Help-with-Filter-in-tMap/m-p/2240467#M27945 <P>Hi,</P> <P>&nbsp;</P> <P>&nbsp; &nbsp;Please try the logic as shown below.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 751px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6gS.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139881i5239CBDB25208352/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M6gS.png" alt="0683p000009M6gS.png" /></span></SPAN></P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="image.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M6gX.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152628i0FC96DF2A9AE0093/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M6gX.png" alt="0683p000009M6gX.png" /></span></SPAN></P> <P>&nbsp;</P> <PRE>!Relational.ISNULL(row1.data) &amp;&amp; row1.data.contains("Balance")</PRE> <P>Warm Regards,<BR />Nikhil Thampi</P> <P>Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sun, 21 Jul 2019 16:13:44 GMT https://community.qlik.com/t5/Talend-Studio/Help-with-Filter-in-tMap/m-p/2240467#M27945 Anonymous 2019-07-21T16:13:44Z