Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Pick (match(Field, 'Secondary School', 'School'), 'Secondary School', 'School') as NewField
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
please provide some sample data and your expected result.
thanks
regards
Marco
The answer provided by Sunny worked - thank you, much appreciated!!
thanks for your response.
please close your thread:
Qlik Community Tip: Marking Replies as Correct or Helpful
thanks
regards
Marco