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

[mabdulh1]

 One point to add is not all employees have hours in both the NTK column and Direct Labour column so the workflow works fine for those employees and the above is only affected with employees in the situation shown above.

[gabrielvilella · Accepted solution]

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.

[Qiu · Accepted solution]

@mabdulh1 
Hope I understand your intention correctly.

[mabdulh1]

@gabrielvilella @Qiu Thank You Both!!

Both Solutions worked,

[Qiu]

@mabdulh1 
Glad to help and thank you for the accept mark. 😁