Field Calculator - find latest PCI

[RobertThomson]

I'd like to look at the fields pci2016 to pci2020 in each record and find the latest year that has a non zero value, then write that value to pci2021.

Is there something simple I can use Arcade or Python or is this beyond field calculator?

TIA

 

[RhettZufelt]

Field calculator will work.  Something like this should do it.  Of course, you will have to modify to match your data.  I didn't have enough "test" fields.

update(!pci2018!,!pci2019!, !pci2020!, !pci2021!)

# and code block 
def update(pci2018,pci2019,pci2020,pci2021):
    newval = None
    if pci2021 !=0:
        newval = pci2021
    elif pci2020 != 0:
        newval = pci2020
    elif pci2019 != 0:
        newval = pci2019        
    elif pci2018 != 0:
        newval = pci2018          
    if newval != 0:
        return newval
    else:
        return None 

R_

[JoshuaBixby · Accepted solution]

Here is another approach besides using elif blocks:

update(!pci2016!, !pci2017!, !pci2018!, !pci2019!, !pci2020!)

# and code block
def update(pci2016, pci2017, pci2018, pci2019, pci2020):
    for newValue in (pci2020, pci2019, pci2018, pci2017, pci2016):
        if newValue != 0:  break
            
    return newValue

[RobertThomson · Accepted solution]

This is the first one I tried, worked perfectly.  Thanks to all for responding.

[DanPatterson]

Or a numpy version

import numpy as np
def last(pci2016, pci2017, pci2018, pci2019, pci2020):
    """Do stuff"""
    flds = [pci2016, pci2017, pci2018, pci2019, pci2020]
    whr = np.nonzero(flds)[0][-1]  # first dimension last nonzero
    return flds[whr]
       
# -- first row in exampe data
last(!pci2016!, !pci2017!, !pci2018!, !pci2019!, !pci2020!)
88

[RhettZufelt]

Or even Arcade:

When($feature.pci2020 != 0, $feature.pci2020,
      $feature.pci2019 != 0, $feature.pci2019,
      $feature.pci2018 !=0, $feature.pci2018,
      $feature.pci2017 != 0, $feature.pci2017,
      $feature.pci2016 !=0, $feature.pci2016, Null) 

R_