Datatable sort issue

Learning Initatives Automation Starter
, ,
1

Capture
Capture211×605 2.34 KB

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

2

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

3

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

image

Regards
gokul

4

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

5

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

Let me know if you have any issue @hcmgl_ei

6

Hey @hcmgl_ei,

Have a look on this video.

Thanks,
Sanjit