Hey there, how to order a datatable with numbers descending? Thanks a lot!

Hi, If you have trouble with SortDataTable activity such as it outputs character-code based sorting, the following LINQ expression will help you. dt = dt.AsEnumerable.OrderBy(Function(r) Double.Parse(r("targetColumn").ToString)).CopyToDataTable OR, if there is non-numeric value including blank in…

Ordering a Datatable

Learning & Development Programs Automation Starter

mahmoud.zaky (Mahmoud Zaky) September 11, 2022, 8:38pm 2

Hi Katarina,
you can sort DT using “Sort Data Table” activity also you can find below video for more support:

also find below documentation for Activity with example

Topic		Replies	Views
How to sort the datatable column if numbers are 123-1,123-2,123-3 Studio studio , question , activities_panel	5	309	October 26, 2023
How to perform Sort (not using Asc or Desc) Activities excel , activities , question	24	1965	March 3, 2021
Sorting columns without sort datatable activity Studio studio , question , activities_panel	10	2861	January 23, 2022
Sort Datatable order by Studio	6	966	November 9, 2022
Is there any way to sort the data table by character type numbers? Studio datatable , activities	3	2441	December 17, 2021

Ordering a Datatable

Related topics