3 Replies Latest reply: Oct 22, 2013 3:45 AM by stuart wannop RSS

    Create a Flag Based on a Text String

    stuart wannop

      Hi Everyone

       

      Wondering if you could help with this. I have a field in a data table that may or may not contain the string "SORD". This could be anywhere in the text string.

       

      What I'd like to be able to do is create a flag (1 or 0) as a new field depending on whether the text string SORD exists in the field. I can do it in Excel but can't get it working in Qlik!

       

      Thanks in advance

      Stu