Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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