Price Data Not Sorting Properly

I am extracting data from a website by using Data Scrapping. Once The data is scrapped and using a write range activity to save it in excel file. After that I am using the read range activity and using Sort Data Table activity to sort “Price” column from ascending to descending order . But its not working the way it should be. Please see the example below :

image

Hi!

please try below query!

dt.DefaultView.Sort = ("[columnname] ASC")
dt = dt.DefaultView.ToTable

also have a view on this thread.

Regards,
NaNi

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