For eg Input: User Name Zablotny, Elaine Benayoun, Michel Benayoun, Michel Hurshman, Robin Output: User Name Zablotny, Elaine Hurshman, Robin It should remove all the duplicate entries from the datatable using linq Kindly help me guys

Hi @Aravinthan , use below Linq Query. (From p in dt.Select() where( From q in dt.Select() where q("User Name").Equals(p("User Name")) Select q).ToArray.Count=1 Select p).ToArray.CopyToDataTable() Regards, Arivu

How to delete all duplicate entries from the datatable using linq

Help

RobertD (Docan Robert) July 1, 2019, 9:07am 5

Please check this.

Topic		Replies	Views
Remove Duplicate Entries with exception of the first one Help datatable , activities	10	7134	October 29, 2018
To Remove Duplicate Rows Studio datatable , excel , uiautomation , activities , studio , question , activities_panel	9	380	April 5, 2024
How to remove duplicates rows data from data table Automation Starter	21	12396	December 6, 2023
How to remove duplicates in data table Studio uiautomation	2	1597	May 28, 2021
How to Get Distinct Records/Remove the duplicate data from a datatable using LINQ in UiPath Tutorials excel , activities , studio , faq , linq , other-products	0	1589	October 7, 2022

How to delete all duplicate entries from the datatable using linq

Related topics