I have a QVD which will run daily and update results on daily basis in that QVD. but i want to take snapshot results from that QVD only on monthly basis .
we are in Feb month so by March 1st Complete Feb Data will be available in the QVD. so i want to take complete Feb month Results which is available in that QVD on march 5th and want to store into a another QVD as a snapshot Data of March 5th.
First Step: i have a QVD loading data on daily basis which will change the data dynamically.
second step : From above QVD i want to take Results on every month 5th of previous Month and store it into another QVD. so every month data should append to this newly created QVD of only new month Results From First step QVD.
Month value is like this 201802, 201803 etc.
Can some help me how to write in script to take snapshot results from existing QVD and store it into new QVD and every month append new months.