Discussion Board for collaboration on QlikView Scripting.
I want to compare 2 field values with WildMatch, for example, Model and SModel both contain ABC and should be recognized as 'match'. But the wildmatch here does exact match. How to solve the problem? Thanks.
LOAD if(wildmatch(Model , SModel),1,0) AS Flag
LOAD * INLINE [
Model , SModel
ABC, ABC D
Go to Solution.
What does qualify a match in your context?
If you want to know if Model is part of SModel, try like this using wildcards '*':
LOAD *, if(wildmatch(SModel , '*'&Model&'*'),1,0) AS Flag
or if you want to know if Model is part SModel or SModel is part of Model:
LOAD *, if(wildmatch(SModel , '*'&Model&'*') or wildmatch(Model , '*'&SModel&'*'),1,0) AS Flag
The matching will be case insensitive, but checking if the e.g. Model is fully contained within SModel.
Thank you! Exactly what I am looking for!