https://community.esri.com/t5/geoprocessing-questions/using-append-after-a-spatial-join-in-modelbuilder/m-p/1550926#M27435 <P>I am attempting to automate a process using modelbuilder. The workflow is as follows: A calculate field is run on an input dataset parameter, then a SPATIAL JOIN is applied to the output. This part works properly. However, Then I want to run an APPEND on the output of the spatial join (AKA, Parameter (3)). However, one of the fields I am attempting to append is linked to the spatial join preceding step; each time the appended field presents itself as INPUT_AddSpatialJoin_#, where the # corresponds to the number of times I have run the spatial join process within the process. This creates an issue as this model will need to be run on a weekly basis, and each time the # value will change and not append properly. A similar issue occurs if attempting to use a fieldmap file for this process, as it uses the outdated # value. Is there a way to work around this, such that the _# can be eliminated from being added to the AddSpatialJoin append field?</P> Tue, 22 Oct 2024 15:15:18 GMT Leah 2024-10-22T15:15:18Z https://community.esri.com/t5/geoprocessing-questions/using-append-after-a-spatial-join-in-modelbuilder/m-p/1550926#M27435 <P>I am attempting to automate a process using modelbuilder. The workflow is as follows: A calculate field is run on an input dataset parameter, then a SPATIAL JOIN is applied to the output. This part works properly. However, Then I want to run an APPEND on the output of the spatial join (AKA, Parameter (3)). However, one of the fields I am attempting to append is linked to the spatial join preceding step; each time the appended field presents itself as INPUT_AddSpatialJoin_#, where the # corresponds to the number of times I have run the spatial join process within the process. This creates an issue as this model will need to be run on a weekly basis, and each time the # value will change and not append properly. A similar issue occurs if attempting to use a fieldmap file for this process, as it uses the outdated # value. Is there a way to work around this, such that the _# can be eliminated from being added to the AddSpatialJoin append field?</P> Tue, 22 Oct 2024 15:15:18 GMT https://community.esri.com/t5/geoprocessing-questions/using-append-after-a-spatial-join-in-modelbuilder/m-p/1550926#M27435 Leah 2024-10-22T15:15:18Z https://community.esri.com/t5/geoprocessing-questions/using-append-after-a-spatial-join-in-modelbuilder/m-p/1554307#M27440 <P>I've come across this issue so it makes using the Add Spatial Join tool impossible to use in modelbuilder as you cannot predict that number. I think its a bug and have reported it to ESRI. But I suspect it won't get fixed. The Add Spatial Join tool was added to Arcpro 3.2. Consider not using that tool and using the <A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/analysis/spatial-join.htm" target="_self">classic spatial join</A> tool. The key difference is that this tool creates an output and does not have that field qualification.</P> Thu, 31 Oct 2024 15:14:48 GMT https://community.esri.com/t5/geoprocessing-questions/using-append-after-a-spatial-join-in-modelbuilder/m-p/1554307#M27440 DuncanHornby 2024-10-31T15:14:48Z