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
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
This is the first one I tried, worked perfectly. Thanks to all for responding.
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_
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
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)
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
