I have the following table
|ID||Po Type||Po Date||Process Date||Value|
in the above table we have Process Date which has 01/01/2017 ie jan2017 data
in feb2017 the above table will be replaced by feb data.
so in Jan in have to create on qvd of jan2017 and in feb2017 again i have to create qvd of feb2017 and concat to jan2017 qvd
so every month the data will be concat
thanks in advance
So what do you need help with buddy?
Generally we would create an Archive QVD at the end of everymonth
For example at the end of Jan Create a QVD for example Archive.QVD
then in Feb
IF today() = Monthend(today()) THEN
Store FACT into Archive.QVD
Then in March you have both Jan+Feb data... hope this makes sense