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")