Datatable sort issue

[hcmgl_ei (HC_ei)]

It gave output like this where I sorted my datatable. Doesn’t process the second digit. Please help me.

[raja.arslankhan (Raja Muhammad Arslan khan)]

Hi @hcmgl_ei Welcome in Community.
please check this one.
Re-Order.xaml (5.1 KB)

[Gokul001 (Gokul Balaji)]

Hi @hcmgl_ei

How about this expression?

(From d in BuildDt.AsEnumerable Where Not (isNothing(d(1)) OrElse String.IsNullorEmpty(d(1).toString.Trim)) Select v = CDbl(d(1).toString.Trim)).OrderBy(Function (x) x)

d(1) → Column name index

Output

Regards
gokul

[hcmgl_ei (HC_ei)]

Thanks everyone. I selected the data table column “string”. It should be “int32”.

[Gokul001 (Gokul Balaji)]

Have you tried with above LINQ expression. It will worked as you need.

Let me know if you have any issue @hcmgl_ei

[Sanjit_Pal]

Hey @hcmgl_ei,

Have a look on this video.

LINQ | Sort Datatable Using LINQ | LINQ Uipath Tutorials | Coderslobby

Thanks,
Sanjit