Find the Maximum value in a Datatable column

Help Studio
, ,
1

Hi,

I’m stuck and need some help. I have a Datatable and I want to get the highest value in Column-1. Is there a way I can do this? Btw, I’m using C#.

Thanks

2

Hi,

Can you try the following expression? this returns max value as double type

 dt.AsEnumerable().Max(r => Double.Parse(r["Column-1"].ToString()))

If there is non-numeric value (including empty), we need to add expression to filter it.

Regards,

3

we would recommend to let us know the datatype of the column value. lets assume doube

YourDataTableVar.AsEnumerable.Max(x => Convert.ToDouble(x["ColName"].ToString())

Also have a look here:

4

Thank you for this. Would I put this in an Assign activity?

5

They’re 5 or 6 figure integers

6

Hi @paulparkes

  1. Drag and drop an Invoke Code activity into your UiPath workflow.
  2. In the properties panel of the Invoke Code activity, create the following arguments:
  • dt (Argument direction: In, Argument type: DataTable)
  • columnName (Argument direction: In, Argument type: String)
  • maxResult (Argument direction: Out, Argument type: Double)
  1. In the Code property of the Invoke Code activity, enter the following C# code:

maxResult = Convert.ToDouble(dt.Compute(“MAX([” + columnName + “])”, “”));

Hope it helps!!

Regards,

7

Convert.ToInt32 method

8

Hi,
If you need assign the result to variable, yes as the following.

image
image863×275 18.7 KB

if you want to assign it to int32 varaible. the following will work.

dt.AsEnumerable().Max(r => Int32.Parse(r["Column-1"].ToString()))

Regards,

9

Thanks for this. I’m now seeing this message:
image

How do I resolve this message?

Thanks

10

Hi,

Can you try the following step?

First, save the xaml file.
Next, close UiPath Studio.
Then restart UiPath Studio.
Re-open the project. then probably automatic recovery will start.

Regards,

11

Thank you so much! :slight_smile: