https://community.esri.com/t5/data-management-questions/selecting-non-duplicate-records-in-two-different/m-p/1030110#M43108 <P>Hi Kelly,</P><P>You can use ArcGIS Pro's Select by Attribute tool.&nbsp; You will select <STRONG>Fields</STRONG> and then choose the appropriate field:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JakeSkinner_0-1614191050409.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/6805iA17E9C478F59DA72/image-size/medium?v=v2&amp;px=400" role="button" title="JakeSkinner_0-1614191050409.png" alt="JakeSkinner_0-1614191050409.png" /></span></P><P>&nbsp;</P> Wed, 24 Feb 2021 18:24:50 GMT JakeSkinner 2021-02-24T18:24:50Z https://community.esri.com/t5/data-management-questions/selecting-non-duplicate-records-in-two-different/m-p/1030105#M43107 <P>Hello!&nbsp; I am trying to find rental properties in my community.&nbsp; I have a parcel shapefile that contains a site address field and a mail address field.&nbsp; If the site address and mail address match, it would be a good indicator that that parcel is not a rental.&nbsp; If they don't match, it should be a rental property.&nbsp;</P><P>My question is this:&nbsp; How do I select those records that do not match between both fields?&nbsp; &nbsp;&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="duplicates.jpg" style="width: 571px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/6804i107C59100693EC99/image-size/large?v=v2&amp;px=999" role="button" title="duplicates.jpg" alt="duplicates.jpg" /></span></P><P>Any help would be greatly appreciated.&nbsp; This seems like a simple task, but I am stumped.&nbsp; Thanks!</P> Wed, 24 Feb 2021 18:11:54 GMT https://community.esri.com/t5/data-management-questions/selecting-non-duplicate-records-in-two-different/m-p/1030105#M43107 KellyHanne 2021-02-24T18:11:54Z https://community.esri.com/t5/data-management-questions/selecting-non-duplicate-records-in-two-different/m-p/1030110#M43108 <P>Hi Kelly,</P><P>You can use ArcGIS Pro's Select by Attribute tool.&nbsp; You will select <STRONG>Fields</STRONG> and then choose the appropriate field:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JakeSkinner_0-1614191050409.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/6805iA17E9C478F59DA72/image-size/medium?v=v2&amp;px=400" role="button" title="JakeSkinner_0-1614191050409.png" alt="JakeSkinner_0-1614191050409.png" /></span></P><P>&nbsp;</P> Wed, 24 Feb 2021 18:24:50 GMT https://community.esri.com/t5/data-management-questions/selecting-non-duplicate-records-in-two-different/m-p/1030110#M43108 JakeSkinner 2021-02-24T18:24:50Z