4 Replies Latest reply: Nov 14, 2012 8:19 AM by Jefferson Martins RSS

    LOAD and wildmatch

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