Multi-Step Field Calculate

Question

I am trying to use python to calculate a field first to put sequential numbers, then pad with leading zeros, then finally to concatenate with a code for each data layer. I set the parameters as the layer, the field, and the 4 digit code. The script that I am using is below. I keep getting an error 539 in the add leading zeros function which says the IDPK_Field is not defined. I am not the best at python, any help would be appreciated! import arcpy arcpy.env.overwriteOutput = False # Script parameters Input_Layer = arcpy.GetParameterAsText(0) IDPK_Field = arcpy.GetParameterAsText(1) CALField = arcpy.GetParameterAsText(2) # Local variables: Updated_Input_Table = Input_Layer Updated_Input_Table__2_ = Updated_Input_Table Updated_Input_Table__3_ = Updated_Input_Table__2_ #Add Sequental Number arcpy.CalculateField_management(in_table=Input_Layer, field=IDPK_Field, expression="autoIncrement()", expression_type="PYTHON3", code_block="""rec=0 def autoIncrement(): global rec pStart = 1 pInterval = 1 if (rec == 0): rec = pStart else: rec = rec + pInterval return rec""") #Add Leading Zeros arcpy.CalculateField_management(in_table=Updated_Input_Table, field= IDPK_Field, expression="str(IDPK_Field).zfill(6)", expression_type="PYTHON3", code_block="") #Add layer Code arcpy.CalculateField_management(in_table=Updated_Input_Table__2_, field=IDPK_Field, expression="CALField + IDPK_Field", expression_type="PYTHON3", code_block="")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

JoanneStarr · Answer

I got it to run withour errors, but it doesn't actually do what I want it to do. Input layer = Airfield accident zone IDPK_Field= AirfieldAccidentIDPK (blank field, text 50 characters) CALField = AAPZ (user defined, not in table anywhere, set as a parameter) The final result is giving me AAPZAirfieldAccidentIDPK rather than AAPZ000001 If I run just the first part of the script, it creates the sequential numbers correctly. But once the second part is ran, it gets rid the newly created sequential numbers and gives me the name of the IDPK field import arcpy # To allow overwriting the outputs change the overwrite option to true. arcpy.env.overwriteOutput = False # Script parameters Input_Layer = arcpy.GetParameterAsText(0) IDPK_Field = arcpy.GetParameter(1) CALField = arcpy.GetParameterAsText(2) # Local variables: Updated_Input_Table = Input_Layer # Process: Add Sequental Number arcpy.CalculateField_management(in_table=Input_Layer, field=IDPK_Field, expression="autoIncrement()", expression_type="PYTHON3", code_block="""rec = 0 def autoIncrement(): global rec pStart = 1 pInterval = 1 if (rec == 0): rec = pStart else: rec = rec + pInterval return str(rec).zfill(6)""") arcpy.CalculateField_management(in_table=Input_Layer, field=IDPK_Field, expression='"' + CALField + str(IDPK_Field) + '"', expression_type="PYTHON3", code_block="")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

JoshuaBixby · Answer

The new error message is saying that autoIncrement is a function with 1 required parameter but no argument is being passed to it. You would need to modify line #17 to include a reference to the field expression="autoIncrement(!{}!)".format(CALField)‍

JoanneStarr · Answer

Hi Randy,

That was helpful! It really is just a simple field calculate, I'm just not very good at Python.

I figured out the error being not defined, but now I am getting "TypeError: autoIncrement() missing 1 required positional argument: 'CALfield'"

I want to use three parameters that are set within the tool, the CALfield is just a 4 letter code that identifies a certain layer, it is not in the original table at all, it is only gained through the set parameter. Basically, I need a code that takes a field, creates a sequential number with 6 digits, then adds the 4 letter code as set in the parameter. I feel like it should be real easy, but I keep getting roadblocked!