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