3 Replies Latest reply: Sep 24, 2013 11:45 AM by Ralf Becher RSS

    Recalculate field in script

    Erik van hout

      At the end of my script I want to recalculate the [Exp hrs].

       

      In one LOAD-statement I'm adding the fields [%Date], [Actual Hours], [Exp hrs] and [Calculation Method] to [MyTable]

      I'm using a JOIN to add the field [Target Prod]

       

      Now depending on the Calculation Method the Expected hours need to be recalculated.

      My join doesn't recalculate all the records in [MyTable]

       

      // use calculation method to recalculate [Exp hrs]

      LEFT JOIN ([MyTable])

      LOAD If ([Calculation Method]=2,

            IF ([Actual Hours]>0, [Target Prod],

            0),

            [Exp hrs])

            as [Exp Hours]

      RESIDENT MyTable;

       

      Drop Fields [Exp hrs];

       

      Can anyone tell me how I'm supposed to recalculate all records?