adding rows during load

[ali_hijazi]

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

[jagan]

Hi,

You can do this, by using AutoGenerate and For loop OR LOAD ....WHILE.

Try this options.

Regards,

Jagan.

[ali_hijazi]

How?

can u give me an example based on the above sample data