adding rows during load

ali_hijazi — Wed, 13 Jun 2012 07:06:12 GMT

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

Re: adding rows during load

jagan — Wed, 13 Jun 2012 09:18:42 GMT

Hi,

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

Try this options.

Regards,

Jagan.

ali_hijazi — Wed, 13 Jun 2012 09:22:49 GMT

How?

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