Get distinct rows

[Shikhar_Tandon]

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!!

[aanandsanraj (Anandraj Rajendran)]

Hi @Shikhar_Tandon

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

[Palaniyappan (Palaniyappan P)]

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

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

Cheers @Shikhar_Tandon

[Shikhar_Tandon]

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

[kommijeevan (Jeevan Kommi)]

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.

[aanandsanraj (Anandraj Rajendran)]

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

[Shikhar_Tandon]

Thanks @Palaniyappan got a lot of help from this.

[Palaniyappan (Palaniyappan P)]

Cheers @Shikhar_Tandon
kindly let know for any queries or clarification