topic Re: WildMatch function with IN Clause in App Development

WildMatch function with IN Clause

kashjaniqlik — Tue, 16 Dec 2014 12:09:36 GMT

Hello

Has anyone come across a IN clause or equivalent to match a list of words against a column in a qlikview table?

I have a list of characters that I need to find in a string and rather than hard-coding it in the qlikview script load, I was wondering if somehow I could validate the script against a previous loaded qlikview table.

In below example, all C1,C2,C3....C15 will go in to the table.

If (WildMatch(Column1,'* C1 *', '* C2 *', '* C3 *', '* C4 *', '* C5 *', '* C6 *','* C7 *','* C8 *','* C9 *','* C10 *','* C11 *','* C12 *','* C13 *','* C14 *','* C15 *'),'Y','N') AS Column1,

Thanks for your help.

Re: WildMatch function with IN Clause

datanibbler — Tue, 16 Dec 2014 12:12:29 GMT

Hi Kash,

try the WHERE EXISTS() clause - that should do what you want.

Re: WildMatch function with IN Clause

kashjaniqlik — Tue, 16 Dec 2014 13:03:50 GMT

Hi - I would like to create a dervied column based on the checks rather than filter the whole dataset through WHERE EXISTS() clause which I presume what you are trying to refer?

Filter:

Load
Column as Column1,

If (WildMatch(Column1, '* C1 *', '* C2 *', '* C3 *', '* C4 *', '* C5 *', '* C6 *','* C7 *','* C8 *','* C9 *','* C10 *','* C11 *','* C12 *','* C13 *','* C14 *','* C15 *'),'Y','N') AS Column1

Resident WildMatch