Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kashjaniqlik
New Contributor III

WildMatch function with IN Clause

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.

2 Replies
datanibbler
Esteemed Contributor

Re: WildMatch function with IN Clause

Hi Kash,

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

kashjaniqlik
New Contributor III

Re: WildMatch function with IN Clause

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

Community Browser