topic Re: Join Field in Model Builder Only Runs once in Geoprocessing Questions

Join Field in Model Builder Only Runs once

MarkYoung — Wed, 14 May 2014 12:54:18 GMT

Hi,
I have a model which works fine. However if I try and run the model again it fails at the Add Join task saying the table is already joined. If I try and add a 'Remove Join' step it asks me to specify the join to remove but there is nothing in the drop down menu.
Any ideas most appreciated.
Thanks
Mark

[ATTACH=CONFIG]33816[/ATTACH]

Re: Join Field in Model Builder Only Runs once

RichardFairhurst — Wed, 14 May 2014 13:23:41 GMT

First of all every time you Add a Join in a model you have to also perform the Remove a Join after your model no longer needs it before the first time you run the model. They should always go into models as a pair.

However, since you already ran the model without doing that and then tried to rerun it in the same session the join has not been removed from memory. You may have to shutdown ArcMap to clear the join from memory and then validate the model again after reopening ArcMap to have it update. Then make sure you add the Remove Join tool before you run the model again.

If any of the model inputs came directly from layers or tables stored in the ArcMap Table of Contents make sure those items did not store the join inside the map. If a join exists on those items, break the join in ArcMap.

Re: Join Field in Model Builder Only Runs once

MarkYoung — Thu, 15 May 2014 07:12:35 GMT

Hi,
Thanks for your post - I added a remove join to the model and it now runs multiple times. Wasn't sure where to put the remove join but I found another old post on the same issue with a diagram

Mark

http://forums.arcgis.com/threads/22985-Joins-do-not-work-in-Modelbuilder-10