Duplication Issue

mabdulh1

Hi,

Just working through this workflow and I am struggling to find the best and most efficient way to manipulate the data and have the result by in the desired format and result in the correct final amounts.

 See below, I need the data grouped by job number and employee name while adding the total hours worked column. 

All while the following occurs:

1. The HR Rate and HR (PPA) Rate tied to Employee #1 pulls in as is for every instance of the Employee that occurs

2. Leave one instance of the NTK Hours and Direct Labour Hours instead of duplicates you see below. For Example Job #5601 brings in the 10 hours of NTK time and 6 Hours of Direct Labour Time twice.

End result would look like this 

Also to get an idea of the workflow currently, see below:

Thanks!!!

gabrielvilella

It is hard to tell if there is anything that you can improve on the workflow because we don't have the file. I would use a summarize tool, group by job numb and employee name, sum hours worked, first NTK and first labour hour.