topic Re: Assigning field name based on user input in Geoprocessing Questions

Assigning field name based on user input

TomPiggott — Mon, 22 Jan 2018 14:51:46 GMT

Hi,

I am trying to create a model where I add multiple new fields to a feature class and to do some other geoprocessing tasks. Is there a way to choose what the field names will be based on user input? I have one field that I add to the feature class which depends on what the data represents and I was wondering if there is a way where I can when running the model select one of two options to what the field should be called. I also wanted to do it so that I could select whether it will add the WAperiod field. I am pretty new to this so I can imagine its something very simple

Re: Assigning field name based on user input

DanPatterson_Retired — Mon, 22 Jan 2018 17:22:15 GMT

As for providing options as to which field name to choose, you can check the 'branching' section of modelbuilder to see how 'if-else' conditions are implemented.

Re: Assigning field name based on user input

curtvprice — Sat, 11 Dec 2021 20:54:53 GMT

It's pretty easy to create a string parameter value filter to set the choices to a limited list of strings. When the model tool is run, it will present a picklist of keywords (which can be the same as the list of field names you want).

Value list filter—Help | ArcGIS Desktop

Model parameters—ArcGIS Pro | ArcGIS Desktop

If you want the model to figure out the name without the user having to know, branching your model (as Dan suggests) is an option, but I think it's easier to use Calculate Value to calculate your field name. Either approach will require some scripting.

# Calculate Value Expression
GetFieldName(r"%table%")
# Code Block
def GetFieldName(tbl):
  # use field name to figure out what sort of table, 
  # if KEYFIELD is not there, returns empty (false)
  # and field name is assigned "FIELDNAME2"
  if arcpy.ListFields(tbl, "KEYFIELD"):
    fname = "FIELDNAME1"
  else:
    fname = "FIELDNAME2"
  return fname
# Data Type
String‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Assigning field name based on user input

TomPiggott — Tue, 23 Jan 2018 20:20:10 GMT

Brilliant! thanks for the help guys