wildmatch function

[QSense]

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(mdbadmin.rootcause.sym,'Altyapi*','*Altyapi','*Altyapi*'),'Altyapı',

if ( wildmatch(mdbadmin.rootcause.sym,'Uygulama*','*Uygulama','*Uygulama*'),'Uygulama',

if ( wildmatch(mdbadmin.rootcause.sym,'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

[#2]

Hello!

If you renamed field as "VardiyaRap_RootCause" in wildmatch function, should use this new field name and no mdbadmin.rootcause.sym, because mdbadmin.rootcause.sym no longer exists.

Regards...

[QSense]

Hi,

I used VardiyaRap_RootCause but it also didnt work

[jeffmartins]

Hi qliekview,

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

See the attached file. Hope it helps you.

Regards

[Nagaraju_KCS]

Hi,

please explain wildmatch function..

i am new to learn..