I am currently struggling to find a cohesive solution to being able to fill nulls with the first instance of a non-null value. The layout is very simple, basically there is column called ID and it contains one non-value null and the rest is null until the next non-value null. I would like it where the nulls are replaced by the most current non-value null.
I have seen solutions utilizing the lag function, group by, and even a recursive data flow. However, I never seem to get those solutions working properly for me.
I would greatly appreciate if anyone can provide a good breakdown of how to implement this solution. Thank you.