Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have monthly snapshots in the form of Excel files. Each of these files generates a Filename_MMDDYYYY.qvd file which all come together in my model. The snapshots are distinguished by an ID field which is the MMDDYYYY from the file name.
Can I incorporate an incremental load so that I only reload a new QVD into my data model and don't have to pull rows from all QVDs every time I do a reload?
All the examples I've seen so far are around updating a single QVD with new rows, but I haven't found anything about loading individual QVDs incrementally.
You can try messing about with the Partial Load feature. See this document for an example: Partial Reload Easy and Simple.
But it will very likely make little difference in load times. Loads from qvd files are very fast if it's possible to do an optimized load. See this blog post for more information about that: https://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/