Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremental recharge

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

1 Reply
JonnyPoole
Employee
Employee

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.