Incremental recharge

Fri, 20 Nov 2020 18:02:30 GMT

Hello good day,

I would like to know as I can, store data daily in a QVD file, without data being lost the day before.

Example

SQL Select * from clickvtemuco;

STORE Table1 into Tabla1.qvd (QVD);

to reload the new data the previous day day lost

Re: Incremental recharge

JonnyPoole — Mon, 30 Nov 2015 17:10:10 GMT

You need to concatenate the QVD based history first

Tabla1:

Load *

from <QVD>;

concatenate (Tabla1)

SQL Select * from clickvtemuco;

STORE Table1 into Tabla1.qvd (QVD);

Then you are always adding. The are more incremental scenarios in the qlikView product help under "QVDs and incremental loads" help topic.