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