I want to make a replace of a null value by the last value before that null or null.
Using LAG in cases where I have 2 nulls or more only does the replace in the first null.
COL1 is the key, COL2 is the original value, and COL3 is the expected result.
(in the explanation in the "-" column, else is all col2)
RESOLVED
Through this question: link
example in image