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
You'll want to order your data, as you need running totals. Stage variables seem to be the best way to do things.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Thanks for your reply. I don't need running total, i need total hours of week1 and week2 for particulat employee and total hours of all employees in week1 as well as week2
Stage variables are still a good way to collect running totals from sorted data. When it's the second week number, append a line terminator and the total to the final column and write to a sequential file, then read from that sequential file to get the desired result. Put the grand total in the user status area and use an after-stage subroutine to append that to the file.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.