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

Help StudioX
,
1

Hi Everyone

I have a Data table consisting of 2 columns and 5000+ rows.

I like to avoid using a for each loop as it will be time consuming so is there an efficient way of searching the WHOLE data table to see which row has the hightest int32 value and get the value from corresponding Column1

Thanks

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)

3

Is it possible to do in just one assign activity?

4

@CGhoST,

Yes, use this LINQ

dtInput.AsEnumerable().OrderByDescending(Function(r) r.Field(Of Object)("Col2").ToString()).Select(Function(r) r.Field(Of String)("Col1")).FirstOrDefault()
5

This is perfect.

Thank you

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.