topic Re: Wildmatch - compare two fields in QlikView

Wildmatch - compare two fields

Thu, 11 Jun 2015 14:26:33 GMT

Hi,

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

];

Re: Wildmatch - compare two fields

swuehl — Thu, 11 Jun 2015 16:42:46 GMT

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

;

LOAD * INLINE [

Model , SModel

ABC, ABC D

];

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

;

LOAD * INLINE [

Model , SModel

ABC, ABC D

];

The matching will be case insensitive, but checking if the e.g. Model is fully contained within SModel.

Re: Wildmatch - compare two fields

Thu, 11 Jun 2015 17:29:41 GMT

Thank you! Exactly what I am looking for!