Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I got a table that contains the following sample data ; dates are in the format of DD/MM/YYYY
Item Date UnitRetail
A 12/1/2012 500
A 15/2/2012 450
A 23/4/2012 400
B 1/1/2012 560
....
what I want is during loading data from database fill the gaps by the last unit retail
i.e.
for Item A I want to fill the dates from 13/1/2012 till 14/2/2012 with the unit retail of 500
and then from 16/2/2012 till 22/4/2012 fill rows with unit retail 450
and then from 24/4/2012 till 31/12/2012 fill rows with unit retail 400
and so on....
is this possible?
Please advise
Hi,
You can do this, by using AutoGenerate and For loop OR LOAD ....WHILE.
Try this options.
Regards,
Jagan.
How?
can u give me an example based on the above sample data