topic Resident Load not like 'string' in QlikView

Resident Load not like 'string'

Mon, 27 Apr 2009 21:29:42 GMT

Hi *,

how can I manage to filter keywords in strings? I'm trying to load URLs that don't contain e.g. "?id=422"

LOAD looks like this:

LOAD url Resident List WHERE url not like '*?id=422*'.

Unfortunately "<>" doesn't work with with wildcards.

Thanks in advance.

Aloah

disqr_rm — Mon, 27 Apr 2009 21:46:17 GMT

Hi Aloha, Try:

LOAD
url as newurl
Resident List
WHERE wildmatch(url, '*?id=422*') = 0;

Thanks

Mon, 27 Apr 2009 21:55:22 GMT

Works. Thanks a lot.