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

    LOAD and wildmatch

    ahnet ceylan

      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