Remove Rows

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.

RemoveDuplicatesWith 0.xlsx

Workflow

Developer

Accepted answers

Hi @spencertony91,

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

I hope it helps.

Remove_duplicates.yxmd

All comments

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!

Hi @spencertony91,

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

I hope it helps.

Remove_duplicates.yxmd

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703