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

Highlighted
Seven 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
Highlighted
Seven 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.

 

Highlighted
Seven 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.

Highlighted
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
Highlighted
Seven 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!

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

 

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

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Downloads and Trials

Test drive Talend's enterprise products.

Downloads