Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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>;
you have to create incremental load script first.
Mafaz,
For doing this we are using Incremental load , check below:
Re: Is it possible to refresh qvd's daily
Thanks,
AS
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
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 |