Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
Hi,
I used VardiyaRap_RootCause but it also didnt work
Hi qliekview,
You can use the pick and wildmatch functions to solve this.
See the attached file. Hope it helps you.
Regards
Hi,
please explain wildmatch function..
i am new to learn..