Hi Everyone I have a Data table consisting of 2 columns and 5000+ rows. I like to avoid using a for each loop as it will be time consuming so is there an efficient way of searching the WHOLE data table to see which row has the hightest int32 value and get the value from corresponding Column1 Than…

@CGhoST , Yes, use this LINQ dtInput.AsEnumerable().OrderByDescending(Function(r) r.Field(Of Object)("Col2").ToString()).Select(Function(r) r.Field(Of String)("Col1")).FirstOrDefault()

Search Maximum Value in Column2 of DataTable and and Retrieve Column1 Data

Help StudioX

CGhoST (John) May 12, 2025, 9:38am 5

This is perfect.

Thank you

1 Like

Topic		Replies	Views
Find the Maximum value in a Datatable column Studio studio , question , activities_panel	11	3441	May 22, 2023
Find Max value from datatable Help datatable	54	26608	December 19, 2021
How to get max value from datatable having string column datatype RPA Discussions datatable , activities , studio , question	8	2243	January 1, 2023
Getting the index of max value in datatable Help	1	1567	June 24, 2019
Get The Max Value For column In Datatable Studio	4	2855	May 10, 2020

Search Maximum Value in Column2 of DataTable and and Retrieve Column1 Data

Related topics