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

Help
, ,
1

Hi,

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.

Regards,
AK

2

@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.

1 Like
3

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

5

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

7

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

8

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

1 Like
9

@Ashwini_Kumaran
For doing it with All Columns have a check here

1 Like
10

Thank you so much, for your help

11

so it is working at your end?

12

Thank you so much! Exactly what I needed!

13

Thanks! That was very helpful!