Hi
You can do something like this:
SELECT MainKey, Subkey,
case when val1 is null then newval1 else val1 end val1,
case when val2 is null then newval2 else val1 end val2,
case when val3 is null then newval3 else val1 end val3
from (select
Hi all,
My df looks like follows:
Situation:
MainKey, SubKey, Val1, Val2, Val3, ...
1, 2, a, null, c
1, 2, null, null, c
1, 3, null, b, null
1, 3, a, null, c
Desired outcome:
1, 2, a, b, c
1, 2, a, b, c
1, 3, a, b, c
1, 3, a, b, c
How could I populate/synchronize empty cells of all records