Ordering a Datatable

[Katarina (Eva Katarina Helbig)]

Hey there,

how to order a datatable with numbers descending?

Thanks a lot!

[mahmoud.zaky]

@Katarina

how to order a datatable with numbers descending

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

UiPath Tutorial || Day 49 : Sort Data Table Activity || Data Table Activities

also find below documentation for Activity with example

Activities - Sort Data Table

[Yoichi]

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 the target column, the following might be better.

dt = dt.AsEnumerable.OrderBy(Function(r) If(Double.TryParse(r("targetColumn").ToString,New Double),Double.Parse(r("targetColumn").ToString),Double.MaxValue)).CopyToDataTable

Regards,