Previous most recent non-zero value

[callmedaddy]

Hello,

I'm trying to set the values of all the months indicating 0 with the previous most recent non-zero value.

For exemple, I have the following:

Jan 1042

Feb 0

Mar 12

Apr 0

May 0

And I want to achieve this:

Jan 1042

Feb 1042

Mar 12

Apr 12

May 12

I want to do this in script. Any solution?

Thanks!

[Gysbert_Wassenaar · Accepted solution]

Something  like this:

load *, If(Value = 0, Peek(NonZeroValue),Value) as NonZeroValue  inline [
Month, Value
Jan, 1042
Feb, 0
Mar, 12
Apr, 0
May, 0
];

[callmedaddy]

Works perfectly! Thank you, @Gysbert_Wassenaar !