Tfilter row is not filtering data that is in the Tfileinputdelimited file

Four Stars

Tfilter row is not filtering data that is in the Tfileinputdelimited file

Hi there,

I am doing simple Tfilter on an account number that I know is in the input file.

For some reason, it is not recognizing the account number.  The component is working "technically" as I checked the reject flow and ALL of the rows from my input file are going to the reject.  I do not know what I am missing.  I attached images to help.

Please help

Thank you

 

Eleven Stars

Re: Tfilter row is not filtering data that is in the Tfileinputdelimited file

Is it trimmed well before sent to tFilter ?

 

or can you attach a sample input.

Regards
Abhishek KUMAR
Four Stars

Re: Tfilter row is not filtering data that is in the Tfileinputdelimited file

Hi there, 

Thanks for responding.  Here is a sample input in excel that I delimited from the text file.

 

Four Stars

Re: Tfilter row is not filtering data that is in the Tfileinputdelimited file

It appears I didn't add the file, here you go.

Eleven Stars

Re: Tfilter row is not filtering data that is in the Tfileinputdelimited file

it works perfectly in my system

 

Talend.JPG

Regards
Abhishek KUMAR
Four Stars

Re: Tfilter row is not filtering data that is in the Tfileinputdelimited file

Thanks Abhishek.  I wonder why it's not working in my system?

Can you please provide 3 screen shots of each of your components selections so I can double check mine?

That would be great.

I'm also going to reboot my computer just in case.

Thanks!

Employee

Re: Tfilter row is not filtering data that is in the Tfileinputdelimited file

Hi,

 

  Please check.

image.png

 

image.png

 

image.png

 

image.png

 

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

 

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads