[IronPython] How can I access a value in a different column as another value in the same row

[Michael Daiy]

I am programatically determining the maximum value of a particular column. I need to get a corresponding value in the same rowfroma different column. How can I go about doing this using IronPython

[Raghav .]

Hello,

Just to understand the question better.

 

You did a max(column1) and then Max(column2) and you want to calculate max(max(column1),max(column2))

 

if you add a screenshot what you want to achieve, would be great to see

Regards

Raghav

[Michael Daiy]

Hello,

 

I have attached an example to help us communicate a little better. I used GetMaxValue() on Column B. This would return 9. The value in column A that I am looking to assign to a variable would be 1. Same row as the maximum value of B.

[Michael Daiy]

example

[Raghav .]

ok, The way i would approach is because programmatically. 1.Get max(B)=9, 2.Identify the rowid of this max value ,i.e. 5 3.Print rowid=5 for column A i.e."corres_col"= 1 This is the logic i can think off.

[Raghav .]

forgot Screen shot showing the logic, the last col is the max(corresponding_colA)

[Michael Daiy]

Thanks for your advice! However I am looking for a solution in ironpython as adding in calculated columns would not work with what I am doing

[Matthew Stahl]

Hopefully the script shown in the screenshot will be of use. If the max value for a column is known, DataTable.Select(expression) will return a RowSelection that can be used to get the value(s) from another row. Note that multiple rows may be returned by the Select if multiple rows of "Column B" contain the maximum value.