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!
TestData.xlsx (9.5 KB)
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
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)
Output
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
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.