Get Min and Max Value from datatable

[ppr (Peter Preuss)]

@kiran.cpavuluri
Welcome to the forum

we can achieve this grouping the data by the empid:

Option 1: filtering on distinct empids and processing the group members

after filtering we can get the:

minVal = dtFiltered.AsEnumerable.Min(Function (x) CDbl(x("oursAllocated").toString.Trim))
maxVal=  dtFiltered.AsEnumerable.Max(Function (y) CDbl(y("Employee ID - COOIS").toString.Trim))

option: LINQ statement

prepare target datatable with build datatable, configure 3 cols: empid, min, max - dtResult

use an assign activity:
LHS: dtResult
RHS:

(From d in YourDataTableVar.AsEnumerable
Group d by k=d("empid").toString.Trim into grp=Group
Let hro = grp.Min(Function (x) CDbl(x("HoursAllocated").toString.Trim))
Let coo= grp.Max(Function (y) CDbl(y("Employee ID - COOIS").toString.Trim)) 
Let ra = new Object(){k, hro, coo}
Select r=dtResult.Rows.Add(ra)).CopyToDataTable

also have a look here:

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…