Find Maximum Value in the column

[Shriharsha_H_N]

Hello,

I want to identify the max value in the column how can i identify and put in the message box

Please find the attached excel file in the max value i need to identify and publish in the message box.

test.xlsx (8.3 KB)

my flow as like this

UsingMaxFunction.xaml (11.5 KB)

please help to resolve the errors

Thanks in advance

[Shubham_Akole]

Double Variable =Datatable.AsEnumerable().Max(Function(row) Convert.ToDouble(row(“ColName”)))

Try this

[Shriharsha_H_N]

@Shubham_Akole I found this error

[Pankaj.Patil (Robot Master)]

Hello @Shriharsha_H_N,

You could do with formula as following

=Max (B2:F10)

you can give a range like A1:A100,

Cheers,
Pankaj

[Shriharsha_H_N]

i need to do in uipath

[Shubham_Akole]

Your Number format is not Proper…
Simple option is sort the Datatable in descending order order using Sortdata table activity…
and Extract 1 value in the column using get row item activity…

[balupad14 (Balamurugan)]

Hi ,
Check this one

UiPath Go ! Datatable Activities

Hi All, Here you can get the datatable related activities. This package includes the below activities that can handle the Aggregation, Cumulative, Add - Delete row range and Export to Xml 1.Add Data Row Range. 2.Remove Data Row Select. 3.Group By Aggregation (Sum,Count,Avg, Max, Min). 4.DataTable to XML Document. 5.DataTable to XML File. 6.Sum,Count,Avg, Max, Min. Name Space [image] [image] https://go.uipath.com/component/datatable-related-activities Regards Balam…

Here is the video demonstration.

UiPath datatable aggregation| change data type of data table| group by

Thank you
Balamurugan.S