Remove Rows

[spencertony91]

I am trying to remove rows in my workflow. I would first want to check if Name is duplicated. If name is duplicated, then i want to go to hours and pay column. If both fields are 0 then i want to remove that row only and keep only the row with data. I only want to delete it if they BOTH equal 0. I have not been able to find anything like this. Any help is greatly appreciated. I have attached a test template. 

[mrbillyjackson]

Hi @spencertony91 

If all of your data follows the pattern in your example, try a Summarize Tool set to:

Group By

    Employee Name

    File Number

Sum

    Current Weeks Hours

    Current Weeks Pay

Hope this helps!

[grazitti_sapna · Accepted solution]

Hi @spencertony91,

I have attached my solution for the problem, please have a look at it.

I hope it helps.

[spencertony91]

This is exactly what I was looking for. Thank you for the assistance.