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?
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.
