5 Replies Latest reply on Aug 3, 2016 5:11 AM by Andrew Watson

    How to replace a null with a value

    Ten Yang

      Hi all,

       

      I am a newbie in Tableau. Please kindly help. I have two table which are left joined. So there are some column is null value in my joined table.

      As a result, my category ID has some null value, but actually we can find a way to replace the null with a known value. For example,, for advertiser id 15413562, we can use 8 to replace all the null value. I was trying to create a new field, but the logistic is not working. Does anyone know how can I fix it in tableau?

       

      Thanks a lot.
      Screen Shot 2016-08-02 at 3.00.12 PM.png