Discussion Board for collaboration on QlikView Scripting.
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
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
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?
Go to Solution.
Try something like
where PathName like '*' & FileName & '*';