Solved: Re: incremental load from qvd - Qlik Community

Report Inappropriate Content · ‎2014-04-22

Hello

I have a question Again about increment load.

Lets say i have an intial load into a QVD.

So my first QVD contains data from 1st Marts to YesterDay.

Then increment from yesterday to today and concatenate this with my initial load (Then i have QVD with all data)

But then i always have to full load this QVD file into a QVW file.

How can i keep my initial load in the QVW, and only load the incremental load into qlikview (but still have all the data for all periods?)

Should i then save the incremental load in different QVDs and load these or what?

Gysbert_Wassenaar · ‎2014-04-22

You can try using Partial Load to do this. But you should really test if simply loading all the data from the qvds isn't just as fast. An optimised load from a qvd is very fast. See this discussion: partial reload

talk is cheap, supply exceeds demand

View solution in original post

Gysbert_Wassenaar · ‎2014-04-22

You can try using Partial Load to do this. But you should really test if simply loading all the data from the qvds isn't just as fast. An optimised load from a qvd is very fast. See this discussion: partial reload

talk is cheap, supply exceeds demand

Roop · ‎2014-04-22

I would collate your QVDs according to need. It may be that you keep a monthly set of QVDs or a totally different set. Generally I would tend to have a set of parallel processes that generate your QVDs according to best fit.

Report Inappropriate Content · ‎2014-04-22

Hi

Thomas,

You will also get the first Qvd data for that you have to make separate QVD here by I attached the rar file that showing the Example of Incremental Load.