Skip to Main Content

Carry Forward

546431Nov 6 2007 — edited Oct 29 2010
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Dec 6 2007
Added on Nov 6 2007
12 comments
4,260 views