I have a few tables of data within my script that I would like to generate snapshots of on a monthly basis and store it in a separate qvd. The reload currently runs daily but I would only need the snapshot of data say on the 25th of each month.
I've tried setting a version and then concatenating it into a qvd but it just overwrites the data rather than adding to it (see the code below)
FINAL: LOAD *, // monthname(addmonths(today(),+1)) as Version // monthname(today()) AS Version date(today()) AS Version // date(today()) as Version RESIDENT FACT_FINAL1; Drop table FACT_FINAL1;
Concatenate(FINAL) LOAD * FROM [..\..\Data\QVDs\VulnerabilitiesSnapshot.qvd] (qvd);
STORE FINAL into ..\..\Data\QVDs\VulnerabilitiesSnapshot.qvd (qvd);