2

I have successfully joined a point shapefile to .CSV file in ArcMap 10.0, and the type of the fields which are related in the two files are the same(text, length:255). But when I remove join and relate the two files, open the attribute table of the shapefile, and click the "Related Table" button, the option is greyed out...The attribute table when clicking the "related table" button How can I solve this problem?

3
  • Please edit the question to specify the exact software releases you are using. The real power in a relate is the use of database indexes. CSV files are NOT in a database, and therefore not indexed, so it doesn't seem a stretch that they wouldn't be supported for join/relate.
    – Vince
    Jun 5, 2016 at 15:43
  • I agree that CSV files are not database, but seems like ArcMap 10.0 support this type of file join with shapefile. Jun 5, 2016 at 16:12
  • 1
    Join != Relate, which might be your issue.
    – Vince
    Jun 5, 2016 at 16:26

1 Answer 1

7

The help for ArcGIS is clear that you cannot do relates with Excel documents or any other document that does not support an ObjectID in the Fundamentals of ObjectID fields help.

This help clearly states:

"If your table lacks an ObjectID field, you won't be able to perform the following operations:

  • Select the features in the layer on the map. Although you can select records in the Table window, including selecting using an expression on Select By Attributes, this selection set is not reflected on the map.
  • Apply a definition query to display only a subset of records or features.
  • Create relates. You can relate to a table without an ObjectID field from a table with an ObjectID field, however. In this case, the relate can be used by the Identify tool to list related records. You can't push selections via the relate.
  • Start an edit session and edit the attributes. However, you can edit the table the layer is based on directly on disk, such as in a text editor if the file is a .txt file. Your changes will then be reflected on the map the next time you refresh the map."

These limitations are only some of the many reasons I always convert Excel and CVS data to geodatabase tables. Indexing is another very big reason to not use these formats if you are dealing with data of any significant size. The performance and functionality gains of conversion far outweigh the inconvenience of having to maintain a one-off version of the data in ArcGIS.

1
  • 2
    The relate function works as long as I convert the .CSV file to geodatabase table using "Table to Table" tools. Jun 8, 2016 at 10:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.