Joining excel table to XYfeat. class: check for field names that match reserved words

TatianaMoreira_de_Souza — Sat, 10 Aug 2013 18:22:17 GMT

Hi all,

I am new to ArcGis, having learned the basics from a book, and I am now trying to join an excel table to a feature class I created from a XYtable. I have summarised the results from the excel table (which was added to ArcMap). Both the feature class and the excel table appear fine but when I try to validate it, I get the message: 'check for field names that match reserved words'. I have checked the reserved words and I am not using any of them. Also, the following message appears:

[INDENT]Field names that match reserved words should not be used in database schema and can cause the join to fail. The following fields match reserved words;
- [NO] from <XYPostcode>

The number of matching records for the join:
- 50 of 20202 records matched by joining [Postcode] from <XYPostcode> with [pccollected] from <Sum_Output_2>.
Matching records may not appear in table view due to join validation errors.[/INDENT]

I would be grateful if someone could help.

Many thanks in advance.

Re: Joining excel table to XYfeat. class: check for field names that match reserved w

SachinKanaujia — Mon, 19 Aug 2013 23:56:41 GMT

NO is a reserved word. ([NO] from <XYPostcode>)

I think you are keeping all records from the join. Check your CSV file XYPostcode which has a field named [NO]. Either rename it or remove it !!!

topic Re: Joining excel table to XYfeat. class: check for field names that match reserved w in Data Management Questions

Joining excel table to XYfeat. class: check for field names that match reserved words

Re: Joining excel table to XYfeat. class: check for field names that match reserved w