Hello, Is anyone familiar with Remove Duplicate Rows (from the DataTable Activities)? I am pulling a large data table from SharePoint but I want to delete rows that have the same code in a certain column. So for example I have 5 columns in my data table and a lot of rows. I want to delete duplicate…

Hi this expression could help you with datatable = datatable.AsEnumerable().GroupBy(Function(a) a.Field(of string)(“yourcolumnnname”).ToString).Select(Function(b) b.First()).CopyToDatatable() if you are not getting asenumberable then kindly have a view on this thread [image] AsEn…

hi @Cormac try rhis [image] Remove duplicate rows based on a value from a single data column Help I want to remove duplicate rows from a datatable if a particular column1 value is duplicate in other rows. dtOutput=dtOutput.DefaultView.ToTable(True,“column1”) when I try…

@Cormac Try below expression. newDT = inputDT.DefaultView.ToTable("True","Column1","Column2",...) Where inputDT is your original input data.

Thanks for the response but I don’t want to delete entire columns I just want to delete entire rows where the same code is found in ‘Column 1’. Does that make sense?

@Cormac It won’t delete entire column. It will give all rows which have unique data.

OK. I see that it won’t delete the entire columns but it doesn’t seem to work for me. The problem is (i think) that the entire row is not a duplicate. There are duplicates in ‘column 1’. I want to delete the entire row if there are duplicate codes in ‘column 1’ even though column 2,3,4 etc may not b…

@Cormac Try this once. newDT = inputDT.Asenumerable().Gropyby(Function(a) a.Field(of string)(“ColumnName”)).Select(Function(b) b.First()).CopyToDatatable()

[image] Palaniyappan: datatable = datatable.AsEnumerable().GroupBy(Function(a) a.Field(of string)(“yourcolumnnname”).ToString).Select(Function(b) b.First()).CopyToDatatable() I can’t get that to validate. Do you know where I am going wrong? [image]

its CopyToDatatable() buddy at last you were almost done Cheers @Cormac

DataTable - Remove Duplicate Row

Help

AshwinS2 (Ashwin S) November 27, 2019, 4:44pm 2

hi @Cormac
try rhis

Thanks
Ashwin S

Topic		Replies	Views
Excel/Datatable Remove ALL Row with duplicate colums Help datatable , excel , activities	17	1730	May 16, 2020
Remove Duplicated Rows using 2 columns Activities excel , activities , question	4	1463	August 6, 2021
How to remove duplicates entries from Row and it should remove that entire Column Help datatable , activities , question	20	3099	November 27, 2019
DataTable Remove duplicate rows Studio studio , question , activities_panel	6	145	July 14, 2024
I want to remove duplicate rows from datatable by comparing single column Studio datatable , activities , question , data_manipulation	14	5403	March 6, 2020

DataTable - Remove Duplicate Row

Related topics