4 Replies Latest reply: Feb 3, 2013 9:22 AM by Raju Kannuri RSS

    wildmatch function

    ali ceyli

      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