topic Load files with datenames in QlikView

Load files with datenames

Anonymous — Wed, 07 Sep 2011 08:07:28 GMT

Hi,

I want to load numerous files that have dates in their names. And i want to load all files execpt the one with todays date.

So a few examples:

Load *

From File_2011-09-01.qvd

(Will load that specific file)

Load *

From File_*.qvd

(Will load all files)

I dont know how to write the variable that's going to narrow my filename so eveyfile except todays will load.

Please help.

Thanks!

martinpohl — Wed, 07 Sep 2011 08:19:07 GMT

Hello,

you can do it like this:

Load * from File_*.qvd (qvd) where filebasename() <> 'File_'&today();

Maybe you have to edit the today-date-format.&date(today(),'YYYY-MM-DD').

Regards

Anonymous — Wed, 07 Sep 2011 09:15:57 GMT

Thanks alot!