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

    Performing calculations during load and creating new fields

      I have two loads in  my script



                                    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$]);




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