Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

QlikView App Dev

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now

Who Me Too'd this topic

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

];

Who Me Too'd this topic