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