Sort a datatable

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @pandeypriyanka1312

Please see if below post helps

Datatable sorting with respect to particular column value

Hi Team, I have a datatable with various columns. I want to sort the rows depending on the column “InvoiceNo.”. Like if the invoice numbers are 001 and 002 then the row that has 001 as invoice number will be the 1st row and then 002 invoice number row as the 2nd row. Please help.

Datatable sorting

@USUSER1 You Can use Filter Datatable Activity and In the Filter wizard Keep Columns Section, Mention the Column Names in the Order you want it. The resultant Datatable will be in that particular Order

Sort datatable data based on one column

GroupBy: Display the name of the item of each Brand. Let: dtBrand as DataTable output from read range activity item as “Brand” as the key and row as the data row value from each brand. First For Each: Using For each activity with Argument Type IGrouping: key of string and element of data row. Set the values property with: dtBrand.AsEnumerable().GroupBy(Function (li) li.Field(Of String)("Brand")) [image] Then log the Brand Name using item.key [image] Second For Each: Using Log Me…

Also, you can consider using sort datatable activity for same.

Activities - Sort Data Table

Hope this helps.

Regards
Sonali