4 Replies Latest reply: May 23, 2018 10:46 AM by Jordy Wegman RSS

    If statement formula

    Aaron Dhobi

      Hi Guys.

       

      I need help with an if statement.

       

      I have two columns in a table.

       

      Column A and Column B

       

      I want to write statement to say

       

      When Column B is NULL to Column A then give the value Unknown

       

      So far i have only wrote an if statement for Column B but it is still not working

       

      if(len(trim(ColumnB)) = 0, 'Unknown', ColumnB) as ColumnB,

       

      Thanks,

      Aaron