AnsweredAssumed Answered

Field Calculating with Python Script using multiple fields and sequential numbering

Question asked by Spencir on Sep 22, 2017
Latest reply on Sep 26, 2017 by CDow-esristaff

I would like help with the proper python script to field calculate a fields value from two separate fields plus a sequential number when there is more than 1 record with the same facility number.  Basically build a expression where the fields  rpsuid + facilityNumber + sequential number if more than two records with the same facility number.  The field waterUtilityNodeIDPK I populated manually to show what I would like the result to look like.  Please notice the record number with the facility number named Comm where there is only one record. In the IDPK field the value is 6705Comm with no sequential number since there is only one.

 

Attribute Table

Outcomes