5 Replies Latest reply: Dec 29, 2017 6:19 PM by Marco Wedel RSS

    Wildmatch on strings

    Tajana Stankovic

      Hi there,


      I am new to Qlik so I'd have a question about Wildmatch if anyone can help. I am looking to match some expressions from a field and assign them to a new field depending on the expression that is found.  The problem I am facing is that the syntax I am using does not give me the result I am looking for :


      Pick (Wildmatch(Field, '*Secondary School*', '*School*'...), 'Secondary School', 'School') as NewField


      In the NewField, both expressions get assigned to 'School' rather than being distinguished between  'Secondary School' and 'School'.



      Any ideas on how to solve this would be much appreciated!


      Thank you