7 Replies Latest reply: Jun 10, 2013 6:07 AM by Jonathan Brough RSS

    How to Update field value if match criteria

      Hi,  i try to update field value by using if statment, however after reload. the data still show unknown......

      (conditions: value update only if the key between two table is the same)

       

      Cost Center:

      CostCode & '|' & Nature as CN,

      CostCode,

      nature

       

      Table_temp:

      NoConcatenate

      load *, CostCode & '|' & Nature as CN

      Resident TableA;

      DROP Table TableA;

       

      Table_final:

      NoConcatenate

      load *,

      if(PartClass='C',

         if(ControlDepartment='Unknown','AM')),

      if(PartClass='E',

         if(ControlDepartment='Unknown','AM'))

      Resident Table_temp;

      DROP Table Table_temp;

       

      Please advice. Many thanks

       

      Mic