topic Re: Add join in model builder in Developers Questions

Add join in model builder

AdamVajda — Fri, 04 Nov 2016 15:54:42 GMT

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!

Re: Add join in model builder

DanPatterson_Retired — Fri, 04 Nov 2016 18:36:33 GMT

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

Re: Add join in model builder

AdamVajda — Fri, 04 Nov 2016 22:14:36 GMT

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.

Re: Add join in model builder

DanPatterson_Retired — Fri, 04 Nov 2016 22:17:41 GMT

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