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

[Anonymous]

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

[luis_pimentel]

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]

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]

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]

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]

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

[jagan]

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.