topic Re: Wildmatch on strings in QlikView

Wildmatch on strings

Anonymous — Sun, 24 Dec 2017 09:44:36 GMT

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

Re: Wildmatch on strings

pradosh_thakur — Sun, 24 Dec 2017 19:56:17 GMT

Pick (match(Field, 'Secondary School', 'School'), 'Secondary School', 'School') as NewField

Re: Wildmatch on strings

sunny_talwar — Sun, 24 Dec 2017 20:05:10 GMT

Your statement looks good because if the WildMatch Finds a match with the first check, it would not need to go the next one... So in that case Secondary School should be picked correctly... may be you need another asterisk between Secondary and School?

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

Re: Wildmatch on strings

MarcoWedel — Thu, 28 Dec 2017 22:21:10 GMT

please provide some sample data and your expected result.

thanks

regards

Marco

Re: Wildmatch on strings

Anonymous — Fri, 29 Dec 2017 14:07:16 GMT

The answer provided by Sunny worked - thank you, much appreciated!!

Re: Wildmatch on strings

MarcoWedel — Fri, 29 Dec 2017 23:19:31 GMT

thanks for your response.

please close your thread:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco