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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
EYamuthan1667195664
Contributor
Contributor

Filter CSV file

How can i fiter a csv file from the tfilelist having file name google-

OCT-221028151700.csv

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hello,

You can uncheck the button "Use Global Expression as Filemask", and setup the Filemask to

"google-OCT-[0-9]+.csv" as the below

0695b00000YEZngAAH.png

View solution in original post

5 Replies
Anonymous
Not applicable

Hello,

You can setup the Filemask as "google-OCT-221028151700.csv" for the component tFileList, thanks

0695b00000YEZhiAAH.png

EYamuthan1667195664
Contributor
Contributor
Author

But I need to filter all the files from the folder with those time stamp

Anonymous
Not applicable

Hello,

You can uncheck the button "Use Global Expression as Filemask", and setup the Filemask to

"google-OCT-[0-9]+.csv" as the below

0695b00000YEZngAAH.png

MAnywar
Contributor III
Contributor III

Hi @Aiming Chen​ , could it also be possible to filter using tJava component?

eg. telling tjava to only process content that contains specific tags (for the sake of xmls) < process>?

So if a file has that tag then it can be processed else dumped and nothing is done, and the next file is read?

Anonymous
Not applicable

Hello MAnywar,

That method is also possible, and the job needs to be revised

 

Best regards

Aiming