Loop in QV

[#1]

Hi guys,

I have a question about the loop in QV. Original I have the date variable, how to expand 12 times of the date starting from the original month+4? You can find the example below, the final table is what I want.

Anyone could help? Thanks!

Original table:

ID	date	score
1	12/2009	80
2	06/2011	50

Final table

ID	date1	date	score
1	04/2010	12/2009	80
1	05/2010	12/2009	80
1	06/2010	12/2009	80
	......
1	03/2011	12/2009	80
2	10/2011	06/2011	50
2	11/2011	06/2011	50
2	12/2011	06/2011	50
	......
2	09/2012	06/2011	50

[CELAMBARASAN]

In script

Load

     ID,

     date,

     score,

     Date(AddMonths(Date#(date, 'MM/YYYY'), 3 + IterNo()), 'MM/YYYY') AS date1

Resident OriginalTable

While IterNo() <= 12;

Hope it helps