replacing missing values with data from the row above AND add 1

Hello there,

im facing a bit of a struggle to get my missing data cleared.

Somehow by exporting my data there are some missing values for position markers. These are always unique for the order number and position.

F.e.

Ordernumber / OrderpositionID

13094223 10.002

13094223 0

13087633 170.001

13087633 0

13094086 10.001

13094086

13094086 20.001

13094086

13094086 0

13092686 10.004

13092686 30.001

13094437 10.004

13094437 0

13094437 20.001

13094534 10.001

13094534 20.001

13094534 30.001

The missing Value node would get me in trouble, since f.e. the first blank value would be set with 10001 but this is 10002 instead.

I tried to do something with the rule engine, but i don´t know how to get the value from the Cell above. I read something from a java snipped that could do this, but the given information wouldn´t work for me.

So the logic that im searching for need to provide me the result like this:

IF missing value = take value from above and add 1 to it.

(The “0” is okay, because there will never be an additional position to the 0-Position)

Thanks for any help on this.