Fill empty field with previous value.

[#1]

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

[lironbaram · Accepted solution]

hei

attach is an example

[#3]

Hi

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