2 Replies Latest reply: Jun 11, 2015 1:29 PM by Jessica Tung RSS

    Wildmatch - compare two fields

    Jessica Tung

      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
          Stefan Wühl

          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.