Store into QVD

[#1]

Hi,

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>;

[alkesh_sharma]

you have to create incremental load script first.

[amit_saini]

Mafaz,

For doing this we are using Incremental load , check below:

Incremental Load.

Re: Is it possible to refresh qvd's daily

Thanks,
AS

[ashfaq_haseeb]

Hi,

Check this

Incremental Load Script

Regards

ASHFAQ

[SunilChauhan]

X:

Load qvd you have generated

then Concatenate

Load *

from excel where Dateavialble=Today()

store X into X.qvd

--------------------> append todays date and overite qvd's

[#6]

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?...

Month	Company	Department	Factory	Buyer
Apr-13	A	Admin	1	Diesel, Hugo Boss
May-13	A	Admin	1	Diesel, Hugo Boss
Jun-12	B	Merchant	2	Hugo Boss
Jul-12	C	Production	2	Diesel, Hugo Boss
Jul-12	D	Finance	1	Diesel
Jul-14	D	Finance	1	Diesel