Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
dreamer78692
Contributor

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

Tags (1)
6 Replies
luis_pimentel
Contributor III

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

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.

MVP
MVP

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

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
Valued Contributor III

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

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.

dreamer78692
Contributor

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

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?

dreamer78692
Contributor

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

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

MVP
MVP

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

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.

Community Browser