2 Replies Latest reply: Nov 4, 2012 2:08 PM by Stefan Wühl RSS

    Question about wildmatch or like

      Hi,

       

      I am trying to use a where-clause in a resident load where I want to keep all values where column A is like column B

       

       

      Result_Table:

      Load

      PathName,

      FileName

      resident YadaYada

      where PathName like FileName;

       

       

      Now that works well, but not when I try to use wildcards.

      I have tried Wildmatch as well but it doesnot work.

       

      I have tried

       

      Load

      PathName,

      FileName

      resident YadaYada

      where PathName like '*FileName*';

       

      But that does not work cause QlikView doesnot recognize FileName when it is inside '*

       

      So, does this work and what is the correct syntax in that case?

       

      Kind regards