How to fill null field with cell value in the top row (several sequential nulls)

Hi!
I need help with a simple case.
I would like to fill the null fields with the value from the cell above. It is possible with lag column, but I have N null fields in a sequence that makes it unfeasible.

image

I tested lag column logic and moving aggregate with loop, but without success.
Can anyone help?

Hi there @tulyorosa.
Take a look a this workflow I made, so you can use it as an example.

You could fix this with one step, using the Missing Value node and selecting Previous Value. It would autocomplete the missing values with the “last value seen”, or previous value.

Configuration:

Before and after running the node:
image

Hope it helps !

Cheers.

2 Likes

OMG!
THANK YOU VERY MUCH!!
I was focusing on complex solutions and you with a node solved it. Perfect! Thank you!

1 Like

You’re welcome. Happy to help.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.