topic Re: Loading CSV File with the newest date in QlikView

Loading CSV File with the newest date

tsoley9262 — Mon, 26 Jan 2026 18:19:17 GMT

I have a folder where a csv file is stored daily with same name but most current date 'pending-reboots.2020-02-04' and i want my script when it runs just to choose the current file any help would be appreciated.

Re: Loading CSV File with the newest date

petter — Tue, 04 Feb 2020 20:58:14 GMT

This should work for you I believe:

FILES1: LOAD * INLINE [FileName]; FOR Each f IN FileList( 'pending-reboots.*.csv') FILES: CONCATENATE LOAD '$(f)' AS FileName AUTOGENERATE 1; NEXT FILES: LOAD MaxString(FileName) AS TheFile RESIDENT FILES1 GROUP BY 1; TheFile = Peek('TheFile'); DROP TABLES FILES1, FILES; LATEST_FILE: LOAD * FROM [$(TheFile)] (txt); TheFile=;

Re: Loading CSV File with the newest date

tsoley9262 — Tue, 04 Feb 2020 20:59:32 GMT

Thank You I will give this a try!!

Re: Loading CSV File with the newest date

petter — Wed, 05 Feb 2020 14:33:22 GMT

Please click the like button or heck if the response was correct you could even mark it as a correct solution.
Believe me - it will be greatly appriciated by the contributors ...
We love likes as much as anyone posting anything on social media