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. 

MatthewDriscoll

Try Calculating the field using Expression Type Python.

Expression:

 

Value<SPAN class="punctuation token">(</SPAN>!Event_type1!<SPAN class="punctuation token">,</SPAN>!Event_type2!<SPAN class="punctuation token">)</SPAN>‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Code Block:

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">Value</SPAN><SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">,</SPAN>y<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>x <SPAN class="operator token">></SPAN> y<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Event_type1"</SPAN>  
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"Event_type2"</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

<SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;"></SPAN>