Wildmatch - compare two fields

[#1]

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

];

[swuehl · Accepted 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

;

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.

[#3]

Thank you! Exactly what I am looking for!