Carry Forward
546431Nov 6 2007 — edited Oct 29 2010Hi All
I was just wondering if there is any function out there to carry forward a value onto x number of lines. I am not using version 10 so I am unable to use last_value.
Basically I have a column such as the one shown below. Where ever there is a null value I need to bring down the last value. Any ideas on how to achieve this?
ID COL_A COL_B
1 10 10
2 NULL 10
3 30 30
4 40 40
5 NULL 40
6 NULL 40
7 NULL 40
8 50 50
9 NULL 50
10 60 60
Any help would be great
Michelle