3 Replies Latest reply: Nov 7, 2014 5:37 AM by Manish Kachhia RSS

    How to replace a null value ?

    Laura Sébille

      Hey everyone,

       

      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