Also LEAD() function can be used with COALESCE() For example coalesce(sepan, lead(sepan, 1) over (partition by sourcedata order by timestamps)) as sepan That will replace NULL values in sepan column with next non null value. The timestamps column could be ordered in asc order depending on the value you wan to copy.
... View more
