Discussion Board for collaboration on QlikView Scripting.
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.XLSIn 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 dataDATA | MONTH | FILENAME | VERSION20090325,MARCH,DATA-20090325.XLS,020090331,MARCH,DATA-20090331.XLS,0 <-20090430,APRIL,DATA-20090430.XLS,020090430,APRIL,DATA-20090430-1.XLS,120090430,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!
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.