Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to append to qvd without having to load the entire qvd

Hi,

The current way we use to append to qvd is get the latest data from the database and then concatenate it to the qvd, however this obviously load the entire qvd.  My qvd is currently 4GB and I do not want to load the entire thing each time Iwant to append new data.

Is there a way to do this.

Thanks,

Dreamer

6 Replies
luis_pimentel
Partner - Creator III
Partner - Creator III

Hi Abdur,

As far as I kown, no it is not. If you want to append new data to a existing qvd you have to load the entire qvd first.

Maybe you could find an extension or a third party software por doing that...

-Luis.

jagan
Luminary Alumni
Luminary Alumni

Hi,

It is not possible to append data to qvd without loading it, instead you can store into new qvd with datetime stamp in file name.  So that next time when you load use wildcard characters for filename.  Try this script

Assume Previous QVD Name : Data.qvd

LET FileName= 'Data' & Date(Today(), 'YYYYMMDD') & '.qvd';

Data:

LOAD

*

FROM DataSource;

STORE Data into $(FielName);

Next time when you are loading this QVDs use this

LOAD

*

FROM Data*.qvd;

Hope this helps you.

Regards,

Jagan.

sudeepkm
Specialist III
Specialist III

Except Buffer incremental load in any other incremental process you will need to load the QVD and then create another QVD with the old QVD name. So if you have not tried the Buffer incremental then please take a look from QlikView reference manual or help.

The QVD is automatically maintained in case of buffer incremental.

Anonymous
Not applicable
Author

Thanks for the reply.

So I should split the qvds based on the date. Is this faster?

Do you have code to this monthly instead of daily?

Anonymous
Not applicable
Author

Just read about the buffer incremental load, and it says that it should only be used for log files?

jagan
Luminary Alumni
Luminary Alumni

Hi,

LET FileName= 'Data' & Date(Today(), 'YYYYMM') & '.qvd';

Data:

LOAD

*

FROM DataSource;

STORE Data into $(FielName);

Next time when you are loading this QVDs use this

LOAD

*

FROM Data*.qvd;

Hope this helps you.

Regards,

Jagan.