How find smallest value in datatable column

thima · October 1, 2019, 9:48am

Hi All,

I want to fetch smallest value from data table column can some one help me on this?
below code i used its not working

Convert.ToDouble(in_mscSitesDT.AsEnumerable().Min(Function(row) row(“MTSOCLLI”)))

Thanks

tbrinkman · October 1, 2019, 10:02am

I got it working by reordering it a bit

in_mscSitesDT.AsEnumerable.Min(function(row) Convert.ToDouble(row(“MTSOCLLI”).ToString))

mhk15 · October 1, 2019, 10:31am

include BalaReva.Datatable.Activities package and try thisMindt.xaml (6.1 KB)

thima · October 2, 2019, 5:44am

Thanks its working fine

system · October 5, 2019, 5:44am

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

Topic		Replies	Views
Find Min value from datatable Academy Feedback	10	2239	July 25, 2019
Get Name which has minimum Marks Activities excel , activities , question	12	418	July 6, 2023
How to findcolumn value based on smallest value of another column in excel Help excel , activities , question	7	1187	March 2, 2020
DataTable - Get the row with minimum value of a given column Help datatable , activities , question	2	2880	November 9, 2019
How to get the datarow with the lowest value from datatable Studio question	3	631	June 5, 2023