[Screenshot 2022-11-16 090034] I am trying to get the bank name with the lowest value from vs BNM (Buy) and put it into the To Buy, may I know how can I do this using UI path?

HI, Can you try the following expression? dt.AsEnumerable.Where(Function(r)r("Bank").ToString<>"BNM").OrderBy(Function(r) Double.Parse(r("vs BNM (Buy)").ToString)).ToArray() Regards,

How to get the name for a maximum or minimum value from a table

Help StudioX

sangeethaneelavannan1 (Sangeetha Neelavannan) November 16, 2022, 3:44am 6

@hjie30 What is the datatype of minval?.Change it to double and try again

Topic		Replies	Views
How to get the Max and Min value from excel and write it to another excel Activities datatable , excel , activities , question	12	3401	March 10, 2022
Calculate the lowest excel value Help datatable , excel , studio , error	4	1233	October 26, 2019
How to find max and min price in the table with linQ method? Studio datatable , studio , question , tools	22	1169	July 21, 2023
Data-table issue - select max value and choose different column value Activities excel , activities , question	3	1795	February 17, 2021
Datatable doubt Studio studio , question , workflow_diff	25	1675	June 11, 2022

How to get the name for a maximum or minimum value from a table

Related topics