How to use sort datatable activity without sorting the column name of that datatable

[AshwinS2 (Ashwin S)]

Hi @rifnanahas

Create a dataview type

Dtview =new dataview (datatable)

Dtview.sort= “employee,manager, category asc”

Use output datatable
Or
Check this

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)< >''"…

Thanks
Ashwin.S