codeblock @ arcpy.CalculateField_management

MarkusSchnitzius — Fri, 11 Oct 2013 08:32:34 GMT

Hi,

I have a table named "street" with a column named "Kategorie", filled with values "0..6". I added a new column named "RULE". I want to fill this column with strings depending on "KATEGORIE". I have a PY-Script and it doesn't work. What is wrong.
I think the problem is the line "expression" or "codeblock". I try to print the result of "myval".The result is a error message "name myval is not defined"

Thank you for your help !

expression = "getKat(!KATEGORIE!)"
codeblock = """def getKat(KATEGORIE):
    if KATEGORIE == "0":
        myval == "Autobahn"
    elif KATEGORIE == "1":
        myval == "Bundesstrasse"
    else:
        myval == "3"
    return myval"""
print "myval", myval
arcpy.CalculateField_management(ERG, "RULE", expression, "PYTHON", codeblock)

Re: codeblock @ arcpy.CalculateField_management

StephanieWendel — Sun, 12 Dec 2021 01:37:32 GMT

It looks like you were actually not assigning any values to myval. You had the double equals sign which is used to test equality not assign values. Try your code like this:

expression = "getKat(!KATEGORIE!)"
codeblock = """def getKat(KATEGORIE):
    if KATEGORIE == "0":
        myval = "Autobahn"
    elif KATEGORIE == "1":
        myval = "Bundesstrasse"
    else:
        myval = "3"
    return myval"""
print "myval", myval
arcpy.CalculateField_management(ERG, "RULE", expression, "PYTHON", codeblock)

topic codeblock @ arcpy.CalculateField_management in Python Questions

codeblock @ arcpy.CalculateField_management

Re: codeblock @ arcpy.CalculateField_management