topic Re: Question about wildmatch or like in QlikView

Question about wildmatch or like

Sun, 04 Nov 2012 19:01:39 GMT

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

Re: Question about wildmatch or like

swuehl — Sun, 04 Nov 2012 19:08:19 GMT

Try something like

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

Re: Question about wildmatch or like

Sun, 04 Nov 2012 19:17:00 GMT

Thanks alot..!!!