Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
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.
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.
Thank you! Exactly what I am looking for!