topic How to Filter filelist in QlikView

How to Filter filelist

Fri, 17 Jul 2015 01:03:38 GMT

What is the best method to exclude files with a specific name? For example if I have a script that wants to loop through a folder picking up every file EXCEPT a file that includes the word 'CAT', how can I do it?

'CAT.xlsx' doesn't get loaded

'Dog.xlsx' does

Wombat.xlsx does

...

I'm attempting to loop using:

for each FoundFile in filelist( Root & '\*.' & FileExtension)

Re: How to Filter filelist

rwunderlich — Fri, 17 Jul 2015 02:11:44 GMT

In your For Loop:

IF (NOT WildMatch('$(FoundFile)','*CAT*')) THEN

LOAD etc

ENDIF

-Rob

Re: How to Filter filelist

Thu, 30 Jul 2015 15:35:48 GMT

Very helpful, thanks rwunderlich‌.