Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
KaisGarci
Contributor III
Contributor III

Load the latest two files

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

2 Replies
jfkinspari
Partner - Specialist
Partner - Specialist

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

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.