5 Replies Latest reply: Apr 4, 2016 8:04 AM by xavier hemelaar RSS

    NOT LIKE

    xavier hemelaar

      Hi Qlikers,

      I'm loading a Table and based on the informations I have in the field 'comment' I would like to build a new field Status.

      LOAD

      comment,

      if(comment like '*Test*', 'Test',

      if(comment like '*Blocked*', 'Blocked',

      if(comment NOT LIKE '*check*' and NOT LIKE '*analyse*', 'To be checked',

      if(comment like ......))))  AS Status

      From ...

       

      Thanks for your help