Updating fields using python in ArcGIS 10

Discussion created by cfw2 on Oct 31, 2011
Latest reply on Nov 2, 2011 by cfw2
I have 10 fields that have a floating value between 0 and 1.  These fields have a meaningless name, so they've been assigned aliases.  I also have three fields called 'First', 'Second', and 'Third' that are empty.  Using python, I want to find the first, second, and third highest of the 10 values for each record and assign the field alias to the First, Second, and Third fields respectively.

For instance, in a given record, if the highest value of the 10 floating numbers was from the field with the alias 'NF', then the field 'First' would get the value 'NF'.  I've been at this for a few hours and I can't seem to make it work.  Any help would be much appreciated.