I am using ArcGIS Pro 2.7.1
My workflow involves ingesting data from various jurisdictions, populating several of the fields and then appending it to a master dataset. I wanted to create a tool simplify the manual part of this task. The tool in ModelBuilder involves a series of spatial joins, joining back to the primary dataset, and field calculations. All input data is the same format (two of the parameters are the same datasets, and the county parcel and soon-to-be-ingested data are all the same structure).
I used sample data form one jurisdiction to build the model. When run as a tool it works flawlessly. However, when I attempt to run it on a different jurisdiction's data it has trouble. The issue seems to lie in the way the join fields are specified. For instance, the dataset I used to put the model together was for Santa Clara County. So when I join and go to calculate a field I specify SantaClara_Work.SRA as the target field.
When I go to use this on a different jurisdiction it instead creates new fields named after the original test dataset. For instance, I tried to use the tool for Kern County and get these messages, and none of the desired field populate:
How do I circumvent this issue and make the tool generic, so I can specify the new jurisdictional data and the relevant county and have it populate appropriately?