Discussion Board for collaboration related to QlikView App Development.
If and storing a excel into QVD, how do I store only information added from today to the QVD except updating old data??
currently am using below code. Thanks in advance..
STORE PLANNING into <PATH> <FILE NAME.qvd>;
you have to create incremental load script first.
For doing this we are using Incremental load , check below:
Re: Is it possible to refresh qvd's daily
Incremental Load Script
Load qvd you have generated
from excel where Dateavialble=Today()
store X into X.qvd
--------------------> append todays date and overite qvd's
when its come to incremental load if I update something it also get changed but what I really what is
I got an excel sheet as below where every month huge set of records get updated so I don't wan't to load old data
Case:- If am in the month of DEC I want to load only the month of DEC, since data up to NOV in the .qvd
I don't want to overwrite, I just want to write only newly added record and If some one do any changes to the old data It should be not loaded from excel.
only >= max to month in excel should be loaded when am initially loading excel.
HOW TO DO IT?...