Hi All,
I am trying to populate blank cell with a value from another column, i.e.
if 'country' is blank then populate with a value from 'country_1'
I tried the below, but it doesn't seem to work.
CASE
WHEN LENGTH(`Country`)=0
THEN `Country_1`
END
Please help!
Thanks
Max