topic Re: Joins Error Message in ArcMap Questions

Joins Error Message

BrynSuggett — Tue, 04 Oct 2022 15:29:50 GMT

Hello,

I'm currently trying to join two sets of data are keep getting an error message when I perform the validation. Would anyone be able to advise me what the issue is please?

I've been through the data I'm trying to link to the other dataset within GIS as I initially thought it didn't like the apostrophe symbol, however, this hasn't changed anything.

There should be 90 matching records and I am asking the system to only keep matching records.

Thanks in advance.

Bryn

Re: Joins Error Message

DanPatterson — Tue, 04 Oct 2022 17:47:07 GMT

as the error said, did you try and rename the Date field in the spreadsheet?

Re: Joins Error Message

JeffHouser — Wed, 12 Oct 2022 14:03:44 GMT

As Dan mentioned, changing the date field in the spreadsheet should fix the validation error for that field. Try not to use field names that are equal to name of a field type or other reserved words.

Also, even though it may be allowed, I would try not to use spaces in field names. If need to, add and underscore. For e.g. Business Name vs Business_Name. Using 10-characters or less for field names is a different topic.

-Jeff