i have one qvd.that qvd contains 3 months of data.(ex:mainqvd contains apr,may,jun upto 24thdate 2015),i am getting the daily data from excel.
mainqvd.qvd(qvd) this qvd contains total data.
Today.xlsx daily excel.
i am concatenating the daily curr_usage: data to prev_usage: now i dnt have any issue.but in future we will get more months of data.that will be added to mainqvd.qvd(qvd) .
that time it will take more time to load mainqvd.qvd(qvd) to concatenate the curr_usage: data.
Now My Requirement is
first i want to split that mainqvd.qvd(qvd) into monthly wise qvd's like apr.qvd,may.qvd,june.qvd.
but thing is june.qvd contains the data upto 24/06/2015 .now when 25/06/2015 data comes i want to add that 25/06/2015 data to june.qvd like this upto 30/06/2015
when 01/07/2015 data comes on that day i want create july.qvd and store the data into july.qvd,when 2/07/2015 data comes that data add to july.qvd like this upto 31/07/2015.when 1/08/2015 comes i want to create august.qvd
do you need to retain all of your data? If you're not, then I wouldn't personally use monthly QVDs. You will introduce a manual overhead to house keep old QVDs and remove them from your file system. I would simply:
Load Previous Data
Concatenate the Daily Data
Store the Data into a QVD where the Date is between your defined start and end dates.