topic Re: Max value geoprocessing , python problem in Python Questions

Max value geoprocessing , python problem

timfajr — Tue, 12 Mar 2019 15:53:34 GMT

Hi.. I'm having some trouble, i want to insert a survey into table on arcgis pro, example: i have two collums a and b, in collum a the value is 5, in collum b the value is 10, i want to display the biggest value so i enter the code: "maxvalue(a, b) and so the result is 10, the problem is i want to display the field name, not the result, so in this case, 5 vs 10=" b", can anyone tell me how to write the code?

Re: Max value geoprocessing , python problem

RandyBurton — Sat, 11 Dec 2021 19:05:47 GMT

Are you thinking of .index in something like:

fields = ['a', 'b']
rows = [[ 5, 10],[20,10]]
for row in rows:
    print max(row), fields[row.index(max(row))]

# results:
# 10 b
# 20 a
‍‍‍‍‍‍‍‍

Re: Max value geoprocessing , python problem

JoshuaBixby — Tue, 12 Mar 2019 19:47:55 GMT

Using field calculator dialog in Pro, set the Expression Type to Python 3, and paste the following into the expression box (not Code Block):

max((!col_a!,'col_a'),(!col_b!,'col_b'))[1]‍