how to take a snapshot data from a Dynamic QVD

[dunnalahk123]

Hi,

I have a QVD which will run daily and update results on daily basis in that QVD. but i want to take snapshot results from that QVD only on monthly basis .

For Example:

we are in Feb month  so by March 1st Complete Feb Data will be available in the QVD.  so i want to take complete Feb month Results which is available in that QVD on march 5th   and want to  store into a another QVD as a snapshot Data of March 5th.

First Step:  i have a QVD loading data on daily basis which will change the data dynamically.

second step : From above QVD i want to take Results on every month 5th of previous Month and store it into another QVD. so every month data should append to this newly created QVD of only new month Results From First step QVD.

Month value is like this 201802, 201803 etc.

Can some help me how to write in script to take snapshot results from existing QVD and store it into new QVD and every month append new months.

Best Regards,

Hari

[clondono]

You should look into Incremental Load.  Check these two postings:

Overview of Qlik Incremental Loading

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

Thanks,
Carlos

[YoussefBelloum]

EDITED

Hi,

you already described what you should do.

try to attach your script to give you the exct script to write to have your snapshots,

you should do like this:

declare 3 variables:

date of today => vToday

Incremental_load_table:

.

.

.

from database where (dynamic dates)

concatenate:

load

.

.

.

from last qvd

//SNAPSHOT

if date = 5 march then

SNAPSHOT:

load

.

.

resident incremntal_load_table;

store Incremental_load_table into PATH\TABLE_NAME_$(vDate).qvd( qvd);

drop table SNAPSHOT;

endif