Load last version of Excel files

Mon, 25 May 2009 21:01:07 GMT

Hi all,
I have to load only the last revision of excel files in a directory. They are named like:

DATA-20090325.XLS, DATA-20090331.XLS, DATA-20090430.XLS, DATA-20090430-1, DATA-20090430-2.XLS

In the example I have to load only the newest revision (if there are) of the last day of month (in bold font).
At the moment i have created a script that create a table with this data

DATA | MONTH | FILENAME | VERSION

20090325,MARCH,DATA-20090325.XLS,0
20090331,MARCH,DATA-20090331.XLS,0 <-
20090430,APRIL,DATA-20090430.XLS,0
20090430,APRIL,DATA-20090430-1.XLS,1
20090430,APRIL,DATA-20090430-2.XLS,2 <-

But I can't load ONLY the latest version of the last "elaborate-day" in every month. (They have an arrow in example above)
Any suggestion? Many Thanks!

Load last version of Excel files

Oleg_Troyansky — Mon, 25 May 2009 22:00:53 GMT

If you already have a table like this, you can use function "FirstSortedValue" to get the first existing date (sorted decending) and then only load those xls files.

topic Load last version of Excel files in QlikView

Load last version of Excel files

Load last version of Excel files