Selecting non duplicate records in two different fields

436
1
02-24-2021 10:11 AM
KellyHanne
New Contributor

Hello!  I am trying to find rental properties in my community.  I have a parcel shapefile that contains a site address field and a mail address field.  If the site address and mail address match, it would be a good indicator that that parcel is not a rental.  If they don't match, it should be a rental property. 

My question is this:  How do I select those records that do not match between both fields?    

duplicates.jpg

Any help would be greatly appreciated.  This seems like a simple task, but I am stumped.  Thanks!

0 Kudos
1 Reply
JakeSkinner
Esri Esteemed Contributor

Hi Kelly,

You can use ArcGIS Pro's Select by Attribute tool.  You will select Fields and then choose the appropriate field:

 

JakeSkinner_0-1614191050409.png