Hi there, I need to remove duplicates from a DataTable using LINQ. Specifically, I need to filter out all duplicates for a single column, maintaining the initial Datatable strucutre. Other methods, such as DefaultView, do not work as they print out only one column (the one containing duplicates). A…

Try this (similar to @Lucas.Pimenta ’s answer but in VB.NET): dataTable = dataTable.AsEnumerable() .GroupBy(Function(i) i.Field(Of String)("columnWithDuplic")) .Select(Function(g) g.First) .CopyToDataTable

Hello! I’m not good with LINQ but try something like this dataTable = dataTable.AsEnumerable() .GroupBy(r => new { columnWithDuplic= r.Field<string>("columnWithDuplic"))}) .Select(g => g.First()) .CopyToDataTable(); If doesn’t work, let’s wait for someone with more experie…

Yup, this one is not working :slight_smile:

what uipath activity are you putting this in? i am trying to do the same thing getting rid of duplicates but am unsure where you put this code. i have used Assign with LINQ but it gives me compile errors with this snippet you have.

The code is in an Assign activity. What errors are you getting?

i have this in the Value textbox of Assign… (From x In dtNew.AsEnumerable() .GroupBy(Function(i) i.Field(Of String)(“Employee ID”)) .Select(Function(g) g.First)) .CopyToDataTable() Error is : ‘)’ expecteed but i dont see where. I added paran’s at the end and before From and after First If i …

Here’s a working example: Main.xaml (12.7 KB) (right click and click Save link as…). If you still can’t get it to work, please upload a .xaml file with a sample DataTable and the Assign activity with the error.

Awesome, that works, thank you! Additionally i need to add a second “ProjectID” column to the Select and GroupBy. I’m trying to add that in as well but cant seem to get it right. I’m not sure if i need to add all the Function stuff again and with different letters (i.e. “e” and “g” like you used…

Hi there @jereed , I believe you will need to regroup and select, as shown below: dtMyDataTable = dtMyDataTable.AsEnumerable.GroupBy(Function(x) x.item("SomeColumnName")).Select(Function(i) i.First).GroupBy(Function(x) x.item("SomeOtherColumnName")).Select(Function(i) i.First).CopyToDataTable This…

Remove Duplicates with LinQ

Help

aksh1yadav (AKSHAY YADAV) October 17, 2017, 12:32pm 6

Hey @ncompa
@Lucas.Pimenta answer will also work he just posted a c# version of Lambda Expressions and workflow supported Vb version so to use that in studion you have to follow the way mentioned by @florin.stan

@Lucas.Pimenta answet will also work just some modification will be needed (VB version) so studion will take it

Regards…!!
Aksh

Topic		Replies	Views
Remove Duplicate Row From Data table using column as the filter criteria Help studio	14	4592	October 1, 2019
How to output duplicates and retain one copy in the data table? Activities datatable , excel , linq	13	1700	April 8, 2022
Is it possible? Datatable matching duplicates using linq Studio studio , question , activities_panel	13	968	July 30, 2022
To Remove Duplicate Rows Studio datatable , excel , uiautomation , activities , studio , question , activities_panel	9	494	April 5, 2024
Remove all Duplicates in Datatable Studio studio , question , activities_panel	10	1328	January 14, 2022

Remove Duplicates with LinQ

Related topics