Dynamic Wildmatch expression

[stevegimbrollmt]

Hi ladies and gents,

I was wondering what is the best approach to take to create a WildMatch search using WildMatch or Like to filter from a list that would be retrieved from a text file. so I would do something like WildMatch.

I have found a similar question but it does not work.  Not sure what is wrong with it.

http://community.qlik.com/message/363088#363088

Can someone give me a helping hand please

Regards

Steve

[Clever_Anjos · Accepted solution]

Try something like this

Patterns:
LOAD * INLINE [
    F1
    8989
    11231
    123123
    13123
    13
    43534
];
List:
LOAD
chr(39)&Concat(F1&'*',chr(39)&','&chr(39))&chr(39) as List
Resident Patterns;
LET Pattern=Peek('List');


Load
  WildMatch(yourfield,$(Pattern))
from yourqvd(qvd).

[stevegimbrollmt]

thanks a lot for the help.

It works