Find Max, Min, Average value from a DataTable UiPath

In the business automation process we always use DataTable.

Assuming we are working with some marks of a student or any other financial calculations of any process.

Let’s see the implementation of finding max min and average values from a DataTable.

Step1: Drag and Drop a Build DataTable Activity and build a datatable as shown below:

Step2: As we have the datatable ready now we need to get the max value from it.

Use the below-mentioned Syntax to get the maximum value from the DataTable:

DT.AsEnumerable().Max(Function(row) cint(row(“ColumnName”)))

Create a variable which can hold this max value as shown below:

Here in the place of columnName entire the column for which you want to calculate Max Value.

Step3: Now we will see how we can calculate the minimum value from the datatable.

Use the below mentioned syntax to get the minimum value from DataTable:

DT.AsEnumerable().Min(Function(row) cint(row(“ColumnName”)))

Create a variable which can hold this minimum value as shown below:

Step4: Finally, we will see how to get the average value from the datatable.

Use the below syntax to get the average value from DataTable:

DT.AsEnumerable().Average(Function(row) cint(row(“ColumnName”)))

Create a variable which can hold this average value as shown below:

This is how you calculate the max min and average values from a DataTable using UiPath.

Now let’s see the outputs of these Assign activity values one after the other as shown below:

The maximum value from DataTable is shown below:

The minimum value from DataTable as shown below:

The average value from DataTable as shown below:

This task will be useful while you are working on a business process that is related to finance or any process which has numbers calculation.

Happy Learning!