... I want to make a QVD on daily basis with a retention period of 10 days say. So every day, a new QVD will create automatically. So at the end of period I will have ..
The second QVD will take data from the last 3 qvd which were created earlier.
So 2nd.qvd have data of ... day8.qvd , day9.qvd and day10.qvd data.
As described earlier I have retention period of 10 days so on 11th day. I have qvd from day2.qvd to day11.qvd and day1.qvd will delete automatically and correspondingly the 2nd.qvd will have data loaded from day9.qvd, day10.qvd and day11.qvd.
You could try to rename all the qvds in the script. Create the 10 qvd (in a begining, when you don't have data for the 10 days, create only empty files). Then delete day1.qvd, and rename the rest:
day2.qvd --> day1.qvd
day3.qvd --> day2.qvd
...
day10.qvd-->day9.qvd
Once this is done, you can create day10.qvd with new data. By working in this way, your script will write always day 10, and read day 8, 9 and 10
