Dynamically update the null values until nonnull values.

[Sarav_93]

Index Currency new_field

0.3 AUD Null

1 AUD 0.043

60 AUD 0.040

72 AUD Null

84 AUD Null

96 AUD Null

108 AUD 0.0426

replace the values for nulls to Row+1 values.

for ex: index 72,84,96 has null values in new_field, has to replace the index vlaue of 108 has 0.0426 has new_field value. similarly for 0.3 index has to replace row+1 has 0.043

[cjaneczko]

Here is one way to do it.