Add join in model builder

2125
3
11-04-2016 08:54 AM
AdamVajda
New Contributor

I am using model builder, and having issues with 'Add Join' tool. It reads the error 000970 index join field, but when I add a field index on the join field the error still occures. Both my inputs are layers. Any suggestions would be greatly appreciated!

0 Kudos
3 Replies
DanPatterson_Retired
MVP Esteemed Contributor

If you can do the join manually using arctoolbox tools, simply go to the results window and check the outputs and messages there to ensure that you have all the appropriate parameters specified in modelbuilder.  If it doesn't work manually, then the problem is the data and not the tool

0 Kudos
AdamVajda
New Contributor

Thanks for your reply Dan.

I attempted the join manually and there were no issues. I also ran the model through the model builder window by pressing the run button and there were no issues (the output files are correct). However, the join error still occurs when I attempt to run the model through the dialog window that appears when double clicking the model.

0 Kudos
DanPatterson_Retired
MVP Esteemed Contributor

It sounds like a join already exists, or the file can't be found when running it that way.