4 Replies Latest reply: Sep 1, 2018 3:39 AM by Priyal Paithankar RSS

    If statement...

    Raman Singh

      Hi,

       

      I am trying to add an IF statement in my where clause on load editor but does not seem to be working. Can someone please help?

       

      The IF statement is being used on two different columns to filter for 'GB'. So as long as one column contains 'GB' then return it.

       

      TABLE:

      IDOriginDestination
      1SYDGB
      2SINAU
      3GBUS
      4GBGB
      5AUSYD

       

      So from the table above it would exclude ID's 2 and 5.

       

      Hope this makes sense.

       

      Thanks