Help with Filter in tMap

Highlighted
Six Stars

Help with Filter in tMap

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  

 

 


Accepted Solutions
Employee

Re: Help with Filter in tMap

Hi,

 

   Please try the logic as shown below.

 

image.png

 

image.png

 

!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 :-)


All Replies
Employee

Re: Help with Filter in tMap

Hi,

 

   Please try the logic as shown below.

 

image.png

 

image.png

 

!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 :-)

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads