Select to view content in your preferred language

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

4097
1
08-10-2013 11:22 AM
TatianaMoreira_de_Souza
New Contributor
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.
Tags (2)
0 Kudos
1 Reply
SachinKanaujia
Deactivated User
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 !!!
0 Kudos