topic Store into QVD in QlikView

Store into QVD

Mon, 08 Dec 2014 04:06:06 GMT

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

Re: Store into QVD

alkesh_sharma — Mon, 08 Dec 2014 04:08:44 GMT

you have to create incremental load script first.

Re: Store into QVD

amit_saini — Mon, 08 Dec 2014 04:34:24 GMT

Mafaz,

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

Incremental Load.

Re: Is it possible to refresh qvd's daily

Thanks,
AS

Re: Store into QVD

ashfaq_haseeb — Mon, 08 Dec 2014 04:48:27 GMT

Hi,

Check this

Incremental Load Script

Regards

ASHFAQ

Re: Store into QVD

SunilChauhan — Mon, 08 Dec 2014 05:08:46 GMT

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

Re: Store into QVD

Tue, 09 Dec 2014 08:07:47 GMT

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