Aggregating data
Posted: Wed Mar 05, 2008 12:00 pm
HI,
I have source data like this
I want the out pu tlike this
for each employee hours of week1 (8 hrs) and also hours of week 2 (14 hrs) and total hours 22 and also hours of all employees of week1and week2 on each day
Can you please tell me how to do this with aggregator stage or any other logic
Thanks
Sri
I have source data like this
Code: Select all
Ubox empno week fri sat sun mon tue wed thu
134 111 1 2 3 3 0 0 0 0
134 111 2 1 2 1 1 2 3 4
134 222 1 1 2 5 1 4 5 6
134 222 2 4 3 4 5 6 7 8
Code: Select all
Ubox empno week fri sat sun mon tue wed thu total gt
134 111 1 2 3 3 0 0 0 0 8
134 111 2 1 2 1 1 2 3 4 14 22
134 222 1 1 2 5 1 4 5 6 24
134 222 2 4 3 4 5 6 7 8 37 51
for each employee hours of week1 (8 hrs) and also hours of week 2 (14 hrs) and total hours 22 and also hours of all employees of week1and week2 on each day
Can you please tell me how to do this with aggregator stage or any other logic
Thanks
Sri