LOAD and wildmatch

[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(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

[#2]

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]

It didnt work

[#4]

Hi,

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

regards

[jeffmartins]

Hi qliekview,

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

See the attached file. Hope it helps you.

Regards