Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
nikita42
Partner - Contributor III
Partner - Contributor III

How do I do an incremental load of monthly snapshot QVDs?

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.

1 Reply
Gysbert_Wassenaar

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/


talk is cheap, supply exceeds demand