Delete only a specific duplicate row of a column

Help Activities
,
1

Hi there,
I would need help to delete only a specific duplicate row and retain all the others.

Delete rows only if the column “Status” has more than a row of value “Return” and keep all the other duplicate rows (for eg: retain the WIP status). Any linq queries will be helpful.

image

2

Hello @niro you can try For each row in your Data Table and use If activity to check if there is some cell with “Return” string on Column Status, if you find it then you can delete the row