Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to perform incremental Excel file loads where dates are written in Excel file names

Hello together.  Just started on this Qlikview adventure and I have already a question concerning incremental loads.  I have found some answers, but none respond to the actual need I have:  We would like to create daily Excel reports to be read into Qlickview.  There are hundreds already and each day an extra file is lying on a file server (with slow connection speed).  Hence I wish to read the files once as an initial load, then only the new files.  To compare the "newness" of the file, I wish to use the date that is written within the filename.  i.e.:

excels for qlikview.GIF.gif

Currently, I have only achieved to open the file, read a date field inside the file, and then to continue.  But this approach seems too slow -  just as fast as re-LOADing all excel files. Any ideas how to make this incremental LOAD work, and to make it performant?  Thank you

0 Replies