AnsweredAssumed Answered

How to find Max value among Fields

Question asked by scop_sts on Mar 13, 2017
Latest reply on Mar 13, 2017 by dkwiens

Good Day GeoNet Community,

 

Would like to inquire how to search among rows of a table and find the maximum value only using a selected set of fields.  For example, If the table consists of five columns ID,F1,F2,F3,F4, would want to search and find the maximum value in F2 and F4.  The maximum value would become an value in a new field, called MX.  An arcpy solution is optimal and generic case is best.

 

Your suggestions are much appreciated, thank you for your time.

Example Table ("MyVals")

IDF1F2F3F4MX
11221333
232655
369566
4778877
599988
6477199
822441233
975331
109452

Outcomes