Calculating a field to list another field's name

[KaydenSim]

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. 

[DavidPike]

What do you want to happen if two events happen in the same year? Can you give an example row in your dataset?

[KaydenSim]

If two events happen in the same year I would want the field to have the name of a third separate column. 

[MattDriscoll1]

Quickly off the top of my head something like this.  Are you trying to do this in a field calculator or in a script?

Event_one = "Event_type1"
Event_two =  "Event_type2"
Last_Event = "last_event_type"

if Event_one > Event_two:
   Last_Event = "Event_type1"
else:
   Last_Event = "Event_type2"‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[KaydenSim]

Thanks for this!!

Preferably in field calculator, but if a python script is the only way to do it, that will have to do. 

[DavidPike]

I'd do it in field calculator with something along the lines Matt laid out, using a code block.

[MatthewDriscoll]

Try Calculating the field using Expression Type Python.

Expression:

Value(!Event_type1!,!Event_type2!)‍‍‍‍‍

Code Block:

def Value(x,y):
    if (x > y):
        return "Event_type1"  
    else:
        return "Event_type2"‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍