5 Replies Latest reply: Apr 3, 2012 8:21 AM by Matthew Fryer RSS

    Performing calculations during load and creating new fields

    jkizanis

      I have two loads in  my script

       

      load

                                    Date as                               Date,

                                    Month(Date) as                     Month,

                                    Year(Date)  as                     Year,

        Day(Date)   as Day,

         Hours as                               OperatorRegHours,

         OTHours as OperatorOTHours

      from OHours.xls (biff, embedded labels, table is [Sheet1$]);

       

       

      load

        Date as Date,

        Month(Date) as Month,

        Year(Date)  as Year,

        Day(Date)   as Day,

         Hours as LaborRegHours,

         OTHours as LaborOTHours

      from LHours.xls (biff, embedded labels, table is [Sheet1$]);

       

       

      Ideally, I would like to have a field called OperatorTotalHours as (OperatorRegHours+OperatorOTHours), a field called LaborTotalHours as (LaborRegHours+LaborOTHours) and a field called TotalHours as  (OperatorTotalHours +LaborTotalHours).

       

      Is it possible to achieve this during load???