Case Statement with multiple conditions and excluding null values
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.
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:
`Column2`is not null
and `Column1`= 'Account A'
What am I doing wrong?