How to select points based on multiple attributes

642
1
05-04-2011 07:05 AM
DuaneEckert
New Contributor
So here is my problem. I have a point feature class with multiple fields. All features will have values in the first field that can be the same value but can also be different. Then the second field will all have values that can be the same value but also can be different. Please keep in mind these two fields are populated with different types of values. I need to be able to select all features that in the first field have a count of more than 1 (groups of duplicates) and those groups of duplicates selected can only be selected if their values in the second field are different from eachother (unique) within the same duplicate group. This sounds confusing but hopefully someone will understand this. Really need some help on this. Thanks
0 Kudos
1 Reply
KenBuja
MVP Esteemed Contributor
One way of doing this would be to run a summary on each attribute. This will give you a table for each attribute that lists each unique value and its count. Join those two tables to the original table and make a selection based on the count fields.
0 Kudos