Help with Filter in tMap

[sunbaj]

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  field and the other is a description.I need to filter out those records where the Description contains the word "Balance"

I have used the below logic but the issue is that it does not filter out the records

StringHandling.INDEX(row2.Description,"Balance") < 1  

[Anonymous · Accepted solution]

Hi,

   Please try the logic as shown below.

!Relational.ISNULL(row1.data) && row1.data.contains("Balance")

Warm Regards,
Nikhil Thampi

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 🙂