Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
];
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
];
Works perfectly! Thank you, @Gysbert_Wassenaar !