Min maks

Help Studio
1

image
image993×907 37.9 KB

This is how I found the min and max from the data, but I also want to get other information about them
other column name and content

2

Hi,

Perhaps you should use OrderBy and First() or Last(), as the following. Can you try this?

image
image850×570 21.3 KB 

details.AsEnumerable.OrderBy(Function(row) CInt(row("targetColumn"))).First()

Regards,

3

hi, I suggest you pass this expression to a Data Row variable using the Assign activity.

With that you can now call the values from other columns or pass on also with an Assign acitivity:

For column 1: dr_DataRowVariable(0).ToString
For column 2: dr_DataRowVariable(1).ToString
and so on…