Adding while Loading

[praveenkumar_s]

Hi,

     How can i acheive this ,during loading

Load EmployeeID, sum(Actualhrs)+sum(Billedhrs)as Totalhrs  resident PPMS_PROJECTRESOURCES;

[sunny_talwar]

Do you want this?

Load EmployeeID,

         RangeSum(Actualhrs, Billedhrs) as Totalhrs

Resident PPMS_PROJECTRESOURCES;

Or this:

Load EmployeeID,

        Sum(Actualhrs) + Sum(Billedhrs) as Totalhrs

Resident PPMS_PROJECTRESOURCES

Group By EmployeeID;

[surendraj]

Hi,

you can try it with preceeding load,

load EmployeeID,sum(Actualhrs)+sum(Billedhrs) as Totalhrs Group By EmployeeID;

LOAD * INLINE [

    EmployeeID, Actualhrs, Billedhrs

    1, 5, 6

    2, 7, 9

];

--surendra

[praveenkumar_s]

Exactly....what i want ... thank u very much..

[surendraj]

Hi Praveen Kumar,

please close the thread if you got the relevant one.

--surendra