topic Re: Why doesn't the Join Field Tool work? in Data Management Questions

Why doesn't the Join Field Tool work?

NikAnderson1 — Thu, 29 Jun 2017 14:09:48 GMT

I have read through many of the other posts that concern the Join Field Tool and none of them have helped in my situation. Not only does the tool run for a very very very long time, it never finishes.

Around every other week I have to update our Parcels Feature Class with new data, I have been doing this for some time now using the Join Field tool and it has always worked with no issues. But now I repeat the same process again and the Join Field tool doesn't even give me a message stating what it wrong, it just keeps running until I get tired of it and hit cancel.

Yes I have ran the tool overnight.

Any help or suggestions? What does this mean?

ArcMap 10.4.1

Re: Why doesn't the Join Field Tool work?

TedKowal — Thu, 29 Jun 2017 14:24:07 GMT

If you have your data in an access database or in a large format database and you are only updating attributes (no geospatial stuff) try making a query outside of arcGIS within the database itself and make those joins. As a practice, I never use ESRI to update attribute data, unless I absolutely have to (generally due to geo spatial links.)

Re: Why doesn't the Join Field Tool work?

NikAnderson1 — Thu, 29 Jun 2017 15:15:30 GMT

Ted,

Thanks for the response.

I am using a regular excel spreadsheet for the data that I need to join, I then usually save it as a Tab Delimited .txt file for the Join. That is what I have always done in the past. Once I join that data I then use that Parcels feature class on our Web Application.

I am not sure if your response is applicable for my use, I don't know if that is something that would give me the final end product that I am trying to achieve.

Re: Why doesn't the Join Field Tool work?

AbdullahAnter — Thu, 29 Jun 2017 18:04:24 GMT

Did you read this question?

I think Dan's answer is helpful for you too.

https://community.esri.com/message/696399-re-oids-and-join-issues?commentID=696399#comment-695071