Fill empty field with previous value.

Wed, 07 Sep 2011 11:00:23 GMT

Hi All,

First one is actual data, the second is the required result.

Code:

let Start = floor(makedate(1971,01,01));
let End = floor(today())+1;

let NoOfDays = End - Start;

Cal1:
Load
$(Start)+recno()-1 as Date
autogenerate
$(NoOfDays);

Cal2:
Load
Year(Date) as Year
resident Cal1;

DROP Table Cal1;

A:
LOAD
Year,
Sales
FROM
SNO.xls
(biff, embedded labels, table is Sheet1$);

Final:
Left Join(Cal2)
Load
Year,
Sales,
Year as Year1
resident A;

Drop Table A;

All kind of suggestions/solutions are most welcome.

Thanks

Gangadharan

Re: Fill empty field with previous value.

lironbaram — Wed, 07 Sep 2011 11:13:19 GMT

hei

attach is an example

Wed, 07 Sep 2011 14:05:58 GMT

Thanks a lot... It's working fine.