Hello Robochamps, Can somebody help me to how to get distinct rows from a given datatable for ex. if their is a datatable named DT1 then i want to get all the distinct rows from table DT1 thanks!!

Hi @Shikhar_Tandon Use below code to get distinct rows in a column dataTable.DefaultView.ToTable(True, <columnName>)

Hi here you go with all expressions that we can use for datatable [image] DataTable filtering with expressions Tutorials Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(…

hi @aanandsanraj , this will only give me the specific distinct column i want all the distinct rows.

Hi @Shikhar_Tandon 1.Use Remove Duplicate Rows Activity in properties pass input Datatable and create output DataTable variable. 2.Use DataTable.DefaultView.ToTable(True,“ColumnName”). Regards, Kommi Jeevan.

@Shikhar_Tandon Then try this code dt.AsEnumerable().Distinct().CopyToDataTable()

Thanks @Palaniyappan got a lot of help from this.

Cheers @Shikhar_Tandon kindly let know for any queries or clarification

Get distinct rows

Help

Palaniyappan (Palaniyappan P ) January 7, 2020, 11:18am 3

Hi
here you go with all expressions that we can use for datatable

Cheers @Shikhar_Tandon

Topic		Replies	Views
How to Remove Duplicate Columns in Excel and have the distinct values in the other sheet Help datatable , excel , activities	7	6478	October 9, 2018
Get distinct value in column excel Help	24	13832	November 19, 2019
Linq query regarding distinct rows Help datatable , activities , question	9	6721	January 7, 2020
Distinct values in a datatable Help datatable	10	29775	April 26, 2022
How to get Distinct values from a Column in DataTable Help datatable	12	4917	November 19, 2018

Get distinct rows

Related topics