Check For Duplicate Row On DT And Mark All The Duplicate With "Duplicate Data"

Hi, I want to search for duplicate row on my excel, based on multiple column(by all the column except last column). After that I want to marked the row with flag “Duplicate Data” on all duplicate row. I try using 2 DT and loop using for each row, but I wanna know if there any other way to do that more fast and efficient. This is the example of data and expected result. Thank you and have a nice day! :slight_smile:
TestData.xlsx (9.5 KB)

Hi @Hendaryie_Tjoeng

Please check this… you can modify as per your requirement

I hope this is what you are looking for

Cheers

1 Like

Thanks for the reply! I will try it

1 Like

Hi @Hendaryie_Tjoeng

How about this expression

(From d In DtInput
Group d By k=d(1).toString.Trim Into grp=Group
Where grp.Count >1
Select grp.toList).SelectMany(Function (x) x).CopyToDatatable

Check out this XAML file

DuplicateData.xaml (11.1 KB)

image

Output

image

Regards
Gokul

1 Like

Thanks for the reply! I’am trying to open the xaml file but unfortunately my version of packages is different, so now I try to update some of the packages. Can you screenshot the flow more close? bcs the ss cannot be zoom

Hi @Hendaryie_Tjoeng

Check out this Screenshot

image

image

Regards
Gokul

1 Like

Thank you very much, thats work nicely, thanks for the effort of screenshoting the flow too, have a nice day!

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.