Restrict Incoming records by conditions in tmap Expression filter

Seven Stars

Restrict Incoming records by conditions in tmap Expression filter

I want to ignore those rows having "UNITED STATES" and pass through those are not "UNITED STATES"

 

When i tried using tmap with condition as below , i  still see values having UNITED STATES 

 

1213.PNG


Accepted Solutions
Nine Stars

Re: Restrict Incoming records by conditions in tmap Expression filter

Hi,

 

Please try below.

 

countryFilter.PNGcountryFilter1.PNG

Regards,

Veeru Boppudi

All Replies
Nine Stars

Re: Restrict Incoming records by conditions in tmap Expression filter

Hi,

 

Please try below.

 

countryFilter.PNGcountryFilter1.PNG

Regards,

Veeru Boppudi
Seven Stars

Re: Restrict Incoming records by conditions in tmap Expression filter

I tried out still not working 

 

below is my entire flow 

1213.PNG

 

Nine Stars

Re: Restrict Incoming records by conditions in tmap Expression filter

Please post tMap configuration.

 

Regards,

Veeru Boppudi
Seven Stars

Re: Restrict Incoming records by conditions in tmap Expression filter

1213.PNG

Nine Stars

Re: Restrict Incoming records by conditions in tmap Expression filter

HI,

please check source data. if you have any spaces for country name and trim before comparing.

 

Regards,

Veeru Boppudi

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.