This content has been marked as final. Show 3 replies
When I load a table, there are some null values in a field. I use this field to perform a join. I would like to replace the null values by a string "Unknown" because otherwise I get some trouble with my join.
I have tried :
if( isnull(fieldA), 'Unknown', fieldA ) as FIELD_A,
but it doesn't do what I want.
Any idea ?
Thanks for your help