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

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

 

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

 

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

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch 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