Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'd like to compare attributes of two point layers . the layers have some similar records and i try to find these . ArcGIS 10.1 has a tool to comparing attributes but i could'nt find any similar tools in ArcGIS 10 . How can i compare two attribute and find similar records?

share|improve this question
up vote 3 down vote accepted

I use this when I have already done a join of my data.
Selecting other fields that are similar (or not).
(Sorry I was out of office and assumed as I use it a key field between the two tables)

In the select by attribute tool.
(Found under the selection pull down)
Mytable1.feild1 = mytable2.field2
Another method (alternative to Aaron's [which his will work great for you])
Is to do a join on the fields that have the same values and select the "Keep only matching records" option.


share|improve this answer
Neson I could'nt use this syntax . could you please describe more detaile? . when i use this syntax, ArcGIS select all of Mytable1.field1 . – wetland Mar 11 '13 at 7:55
Thanks All. @Brad said i can use join. it helps me alot .I use Join and relate and solve the problem . – wetland Mar 11 '13 at 18:59

Try using Feature Compare (Data Management):

Compares two feature classes or layers and returns the comparison results. Feature Compare can report differences with geometry, tabular values, spatial reference, and field definitions.

Alternatively, use Table Compare (Data Management):

Compares two tables or table views and returns the comparison results. This tool can report differences and similarities with tabular values and field definitions.

share|improve this answer
+1 I use these two tools lots in my current project – PolyGeo Mar 11 '13 at 3:24
based on @Areon table compare is great for me and i use it for another problem . – wetland Mar 11 '13 at 19:00

There are multiple GP tools available in ArcGIS 10, such as 'Find Identical' and 'Delete Identical'. Please refer to these Esri KB articles to find out more:

Just in case you want to get access to more advanced tools on GIS data management within your business workflows regarding to finding similar features both geometry and attribute wise, consider taking a look at the ArcGIS Data Reviewer 10 (the link on managing duplicate geometries).

share|improve this answer
I have two layers ( layer A and layer B) and i want to compare records of a field in layer A to layer B. the location of points not same. i don't have any duplicate data . – wetland Mar 10 '13 at 21:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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