store historic Data

[gauravgg]

Hi

I have the following table

ID	Po Type	Po Date	Process Date	Value
1	A	01/09/2016	01/01/2017	1000
2	A	05/10/2016	01/01/2017	4000
3	B	06/11/2016	01/01/2017	5000

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

[vinieme12]

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

FACT:

load

Archive.QVD  

concatenate

Monthly:

Load

Feb.qvd

IF today() = Monthend(today()) THEN

Store FACT into Archive.QVD

End IF

Then in March you have both Jan+Feb data... hope this makes sense