Question about wildmatch or like

[#1]

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

[swuehl · Accepted solution]

Try something like

where PathName like '*' & FileName & '*';

[#3]

Thanks alot..!!!