Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Load last version of Excel files

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!

Tags (2)
1 Reply

Load last version of Excel files

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.

Community Browser