Take snapshot from existing qvd file

[pankaj999]

Hi,

I have a requirement to show progress by months with a snapshot data.

I need to compare data on a snapshot basis.

Now what I need to do is that I have a qvd that is dynamic and gets updated daily. I want to take snapshot from that file on 15th of every month with 30 days range.

My data looks like this

Sales ID   Sales   Date

       1           123     04-23-3019 

        2          456     01-23-3019 

 How can i write load script to store snapshots every 15th day of the month as qvd?

[miskinmaz]

Hi,
You need to compare the today's date if it is 15th or not.
If it is true then store the qvd else ignore the storing part. For a 30 days range you can use the where exist condition to filter the data from 15 to minus 30 days.