Search Maximum Value in Column2 of DataTable and and Retrieve Column1 Data

Help StudioX
,
2

@CGhoST,

You can get the desired value like this.

Get Maximum value:

intMaxValue = dtInput.AsEnumerable().Max(Function(r) CInt(r.Field(Of Object)("Col2").ToString()))

Get Column 1 of the maximum value

strOutput = dtInput.AsEnumerable().Where(Function(r) r.Field(Of Integer)("Col2") = intMaxValue).Select(Function(r) r.Field(Of String)("Col1")).FirstOrDefault()

Output:

A screenshot of a UiPath workflow showing a sequence that builds a DataTable, assigns maximum values, outputs a string, and logs a message, with debug information visible on the side. (Captioned by AI)
A screenshot of a UiPath workflow showing a sequence that builds a DataTable, assigns maximum values, outputs a string, and logs a message, with debug information visible on the side. (Captioned by AI)2239×1228 102 KB

Sample Code:
MaxCountDemo.zip (33.9 KB)