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

View solution in original post


All Replies
Highlighted
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 :-)

View solution in original post

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog