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…

DataTable - Remove Duplicate Row

Help

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

hi @Cormac
try rhis

Thanks
Ashwin S

1 Like

Topic		Replies	Views
REmove duplicates from datatable excel Help datatable , activities , question	13	2019	November 14, 2019
Remove duplicate rows based on a value from a single data column Help	8	14823	October 29, 2018
How to remove rows with duplicate columns Help datatable , excel , activities , question	12	8550	November 30, 2019
Remove Duplicated Rows using 2 columns Activities excel , activities , question	4	1212	August 6, 2021
How to Remove Duplicate Row If the Value from two Columns matched Activities excel	5	2367	March 13, 2022

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

DataTable - Remove Duplicate Row

Related Topics