Hi All,
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.
ex:
prev_usage:
Load
Dir,
date,
space
from
mainqvd.qvd(qvd) this qvd contains total data.
concatenate
curr_usage:
Load
Dir,
date,
space
from
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
how to achive this?
help me on this...
regards,
kd
