Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

QSense
Contributor II

LOAD and wildmatch

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

4 Replies
Not applicable

Re: LOAD and wildmatch

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...

QSense
Contributor II

Re: LOAD and wildmatch

It didnt work

Not applicable

Re: LOAD and wildmatch

Hi,

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

regards

jeffmartins
Contributor II

Re: LOAD and wildmatch

Hi qliekview,

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

See the attached file. Hope it helps you.

Regards

Community Browser