I am trying to create a case statement where I have a new column that replaces a value in column1 with a value from column 2 but only if column 2 is not null. If it is null, then the value in column1 needs to remain the same.
Sample table:
I need it to look like this:
So "Account A" is replaced with "name" from column 2 when it is available.
I have tried this but it is not working:
(CASE
when
`Column2`is not null
and `Column1`= 'Account A'
then `Column2`
else `Column1`
End)
What am I doing wrong?