I read the mail I separated data in mail I searched the web and got the price of the data. I wrote to build data I want to choose the most expensive and cheapest and put them on queue [image] [image]

hi @Yurdanur_Yusuf , You can use the “Sort Data Table” activity to sort your data table from the cheapest (Ascending order) or from the most expensive (Descending order). The cheapest/most expensive will be at the top of the sorted data table. [image]

Filterr

Help Studio

raja.arslankhan (Raja Muhammad Arslan khan) September 29, 2022, 7:26am 3

@Yurdanur_Yusuf

DT.AsEnumerable.OrderBy(Function(x)Cdbl(x(1).ToString)).First.ItemArray //Row having Minimum Value
DT.AsEnumerable.OrderBy(Function(x)Cdbl(x(1).ToString)).Last.ItemArray //Row having Maximum value

Topic		Replies	Views
Sort data Tablee Studio	3	571	September 30, 2022
Problem on filtering datatable with lowest prices (second) Studio datatable , robot , activities , studio , question	3	411	June 14, 2023
If activite Studio	8	637	September 29, 2022
How to sort data table retreived from Data scraping? Studio studio , question , project_panel	3	984	August 17, 2022
Take the second lowest price row in data table Studio studio , question , extension	10	857	October 25, 2023

Filterr

Related topics