topic LOAD and wildmatch in QlikView

LOAD and wildmatch

QSense — Tue, 13 Nov 2012 19:05:49 GMT

Hello ,

I have a sql statement getting data from db

İn load expression I want to get a conditional data seen below

load *,

if ( wildmatch(VardiyaRap_RootCause,'Altyapi*','*Altyapi','*Altyapi*'),'Altyapı',

if ( wildmatch(VardiyaRap_RootCause,'Uygulama*','*Uygulama','*Uygulama*'),'Uygulama',

if ( wildmatch(VardiyaRap_RootCause,'Planli Calisma*','*Planli Calisma','*Planli Calisma*'),'Planli Calisma'))) as KOKNEDEN

;

sql :

select ...

mdbadmin.rootcause.sym as VardiyaRap_RootCause,

but I have getten error fields not found

Re: LOAD and wildmatch

Tue, 13 Nov 2012 20:37:40 GMT

Thus test to see if it works,

if(wildmatch(VardiyaRap_RootCause,'Altyapi*','*Altyapi','*Altyapi*')>0,'Altyapı',

if(wildmatch(VardiyaRap_RootCause,'Uygulama*','*Uygulama','*Uygulama*')>0,'Uygulama',

if(wildmatch(VardiyaRap_RootCause,'Planli Calisma*','*Planli Calisma','*Planli Calisma*')>0,'Planli Calisma',VardiyaRap_RootCause))) AS KOKNEDEN

Regards...

Re: LOAD and wildmatch

QSense — Wed, 14 Nov 2012 07:35:08 GMT

It didnt work

Re: LOAD and wildmatch

Wed, 14 Nov 2012 09:46:45 GMT

Hi,

you should first load data from sql table without wildmatch applying. Wildmatch perform on VardiyaRap_RootCause attribute of corresponding resident table.

regards

Re: LOAD and wildmatch

jeffmartins — Wed, 14 Nov 2012 13:19:21 GMT

Hi qliekview,

You can use the pick and wildmatch functions to solve this.

See the attached file. Hope it helps you.

Regards