Sort Data Table does not give expected result

I put the “Order” to Ascending and i get this:
image

Hi @atomic,

try this

SortedDT =

DT.AsEnumerable().OrderBy(Function (f) CInt(f(“ColumnName”))).ToArray.CopyToDatatable

put your column name instead of “ColumnName” in above code.

2 Likes

Hi.
How about changing the expression style on excel?
to number

Thank you, it works great!

Why does your solution work but the “Sort Data Table” activity doesnt?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.