Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Wildmatch - compare two fields

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

];

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Wildmatch - compare two fields

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.

2 Replies
MVP
MVP

Re: Wildmatch - compare two fields

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.

Not applicable

Re: Wildmatch - compare two fields

Thank you! Exactly what I am looking for!

Community Browser