Error while reclassifying slope value using calculate field

KedaravindanBhaskar

Hello, I am having trouble reclassifying slope value into a new field.

I have attached an image with the dialogue box for the calculate field tool, including the code I am using.


Something(s) to consider - I am using the tool in the workflow for a model and have used an iterator before the tool. Hence the "%Value%_Slope_Type"(Inline variable substitution). I also tried executing the tool outside the model but I get the same result.

The error message I receive is as follows -  ERROR 000013: N_Slope_Type already in N_Sample_Lines
Failed to execute (Calculate Field).

I am using ArcGIS Pro version 2.9.0.

Any help would be greatly appreciated. 

Regards, Kedar

 

curtvprice

Hi Dan. 

Here's my fix

Field Name: %Value%_Slope_Type 

Expression: reclass(!%Value%_Slope!) (I am assuming this is a field name (of a numeric field in your table, since you are doing a numeric comparison in your code block)

Code Block: (unlike label expressions you must use a local variable here. Make sure you handle the 0 or None [null]  case)

 

def reclass(vs):
    if vs < 0: 
        return 1
    elif vs > 0:
        return 2
    else:
        return 0

 

 

The error message (ERROR 000013: N_Slope_Type already in N_Sample_Lines) may reflect that first time @KedaravindanBhaskar  ran the model the field N_Slope_Type didn't exist yet, so the field existed already from then on but ModelBuilder didn't know it so tried to add it hence the error.  The Calculate Field tool has the capability of creating a field as it runs, but because of ModelBuilder validation issues I do not use this feature as it may work the first time but not in future iterations because of validation confusion (the validation tells GP the field does not exist but in iteration two or another run, it exists!) (I think this was a bad design decision, but I'm sure they had their reasons.)  When I am creating a new field I run the Add Field tool first (in your case adding the field %Value%_Slope_Type) because if the field exists, Add Field just passes a warning and moves on.

Hope this helps.