get field value returns 1

PaulLohr

Anyone have thoughts about why the Get Field Value tool would return "1" instead of the first value of the specified field? In many cases Get Field Value does what it should - it returns the expected value. In a few cases it returns "1" which is not even a choice in the specified field. The field referenced by Get Field Value uses a sting data type.

This is the process string that uses the Get Field Value tool:

Select Layer by Location > Make Feature Layer > Summary Statistics > Add Join > Get Field Value

Calculate Field calls Get Field Value's output using the format "%inline_variable%".

Thanks for any help,

Paul Lohr

curtvprice

Paul, I have a cute little method I use with the Calculate Value tool that is much more flexible than that tool.

To use it, choose a function below for the code block, and then use an expression like:

get_first(r"%table%")

# Like GetFieldValue
def get_first(tbl, fld):
  return next(arcpy.da.SearchCursor(tbl, fid))[0]
# Get max
def get_max(tbl, fld):
  return sorted(arcpy.da.SearchCursor(tbl, fid))[0][0]
# Get min
def get_min(tbl, fld):
  return sorted(arcpy.da.SearchCursor(tbl, fid), reverse=True)[0][0]

BTW, if you have that bug number, please add it to this thread.