case when condition for replacing null value to string and non-null values to keep it as same.

Hi team,

I am trying to execute the below condition which is if the column has null values (∅) symbol, I want to replace that into 'no data'  string. If not the value should remain the same as the column.
While trying to execute this, I am getting error because one condition result is string if not the other is a number. How to overcome this issue?

sql:

CASE WHEN ${my_measure} IS NULL

THEN "No Data"

ELSE ${my_measure}

END ;;

0 1 111
1 REPLY 1
Top Labels in this Space
Top Solution Authors