How to retrieve duplicate rows from a data table by comparing all column


I have extracted the data from an excel which is currently dtExcel and it has duplicate values, now i have to extract only the duplicate values from dtExcel by comparing all the columns.


@Ashwini_Kumaran, I had a project where I needed to do that, I used the below activity pack by @Alex_Vasile
it was very easy and efficient.

Otherwise @Ashwini_Kumaran, generously built these example workflows for the community, you can download that and modify it.

I have only one data table within which I need to retrieve the duplicate records @SenzoD

You want to compare the rows using ALL the columns? Dont you have a key column?

Okay, How to find duplicate rows in a data table by comparing values of one column

for doing it with e.g one column / key find starter help here:
FindDupsUniquesFirstFromGroup_By1Col.xaml (8.4 KB)

1 Like

For doing it with All Columns have a check here

1 Like

Thank you so much, for your help

so it is working at your end?

Thank you so much! Exactly what I needed!