Sort data Tablee

Help Studio
1

image
image642×588 15.1 KB

I have a data with the price of the products
I want to choose the cheapest product and the most expensive product
but it sorts by first digit
1599
499
529
599
sorting is not the way I want it to be

2

HI @Yurdanur_Yusuf

Check out the XAML file

Low & Highest Price.xaml (7.6 KB)

Note : Instead of Build Data Table use Excel (Read Range activity)

Output

image

Regards
Gokul

3

Check out the Video Link @Yurdanur_Yusuf for Sort Data Table

Regards
Gokul

4

Hi @Yurdanur_Yusuf,

You can try this assign and after write dtNewUrun to excel.

dtNewUrun = dtUrun.AsEnumerable().OrderBy(Function (row) CINT(row(“Ürün Fiyat”))).Select(Function (row) row).ToArray.CopyToDatatable()

Kind Regards.