AnsweredAssumed Answered

Calculating a field to list another field's name

Question asked by Kayden_Sim on Jul 10, 2020
Latest reply on Jul 13, 2020 by MBDriscoll

Hi Esri community, 

I have two fields that represent different event categories, each denoting the year a given event category occurred. 


I want to calculate a new field that will list the field name of the event type with the maximum value (latest year). 

Is there any way I can do this? 


For example:


Event_type1 ;  Event_type2,  last_event_type

     1984                1972            event_type1 


Thanks for any help!!


- Also, I posted this in the Python community because I thought there might be a script that could perform this action, but if there is a better geonet community for this question please let me know.