topic Load the latest two files in QlikView

Load the latest two files

KaisGarci — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I have a folder from which qlikview load the excell files. I want him to load the latest 2 files from this folder based on the computer time and date if possible.

Can anyone help me please ?

Thank you

Re: Load the latest two files

jfkinspari — Mon, 24 Aug 2020 09:23:19 GMT

You could accomplish this making by iterating over all files and find their last modified date and time by using the FIletime() function. Then doing a FIRST 2 LOAD on the rows sorted by the new timestamp field

Re: Load the latest two files

Brett_Bleess — Tue, 08 Sep 2020 15:41:23 GMT

The only thing of which I can think that may provide some additional help is the following Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/Preceding-Load/ba-p/1469534

May provide some further help around trying to most efficiently do things.

Regards,
Brett