topic Tfilter row is not filtering data that is in the Tfileinputdelimited file in Talend Studio

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

rwnetwork — Thu, 21 Feb 2019 15:49:07 GMT

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

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

akumar2301 — Thu, 21 Feb 2019 15:51:41 GMT

Is it trimmed well before sent to tFilter ?

or can you attach a sample input.

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

rwnetwork — Thu, 21 Feb 2019 20:41:26 GMT

Hi there,

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

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

rwnetwork — Thu, 21 Feb 2019 20:54:02 GMT

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

SampleInput.xlsx

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

akumar2301 — Thu, 21 Feb 2019 22:16:37 GMT

it works perfectly in my system

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

rwnetwork — Thu, 21 Feb 2019 23:00:39 GMT

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!

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

Anonymous — Fri, 22 Feb 2019 08:30:20 GMT

Hi,

Please check.

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 🙂