Creating Snapshots of data

khaycock — Sat, 16 Nov 2024 20:53:59 GMT

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

Any ideas on the best way to do this?

Re: Creating Snapshots of data

OdieW — Fri, 06 Sep 2024 11:53:19 GMT

Old post I know, but I just posted a similar question before I found yours. Did you ever find a good way to do this?

topic Re: Creating Snapshots of data in QlikView

Creating Snapshots of data

Re: Creating Snapshots of data