[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

hjie30 (Marcus) November 16, 2022, 5:22am 8

Okay the data type change fixed the issue, but now I have another issue with the column “vs BNM (Buy)” May I know how to solve it? The vs BNM (Buy) is present in table sheet1, I even copy the column name but seem like doesn’t work

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