Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
rwnetwork
Creator
Creator

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

 

Labels (1)
  • v7.x

6 Replies
akumar2301
Specialist II
Specialist II

Is it trimmed well before sent to tFilter ?

 

or can you attach a sample input.

rwnetwork
Creator
Creator
Author

Hi there, 

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

 

rwnetwork
Creator
Creator
Author

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


SampleInput.xlsx
akumar2301
Specialist II
Specialist II

it works perfectly in my system

 

0683p000009M3GH.jpg

rwnetwork
Creator
Creator
Author

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!

Anonymous
Not applicable

Hi,

 

  Please check.

0683p000009M3KM.png

 

0683p000009M3GV.png

 

0683p000009M3KR.png

 

0683p000009M3KW.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 🙂