https://community.esri.com/t5/arcgis-pro-questions/find-matches-in-two-fields/m-p/1224309#M61383 <P>Hi all,</P><P>I have been working on a project comparing two data sets. What I need to do is identify points that have two fields matching--Street address and unit # both need to match. I have tried using the intersect tools but when looking at the attribute table for the intersect layer, I notice that one of the fields match, but not both. Any ideas for how to go about ensuring both fields match for all points?</P><P>Thanks in advance!</P> Fri, 21 Oct 2022 16:49:09 GMT Isaac-Suh 2022-10-21T16:49:09Z https://community.esri.com/t5/arcgis-pro-questions/find-matches-in-two-fields/m-p/1224309#M61383 <P>Hi all,</P><P>I have been working on a project comparing two data sets. What I need to do is identify points that have two fields matching--Street address and unit # both need to match. I have tried using the intersect tools but when looking at the attribute table for the intersect layer, I notice that one of the fields match, but not both. Any ideas for how to go about ensuring both fields match for all points?</P><P>Thanks in advance!</P> Fri, 21 Oct 2022 16:49:09 GMT https://community.esri.com/t5/arcgis-pro-questions/find-matches-in-two-fields/m-p/1224309#M61383 Isaac-Suh 2022-10-21T16:49:09Z https://community.esri.com/t5/arcgis-pro-questions/find-matches-in-two-fields/m-p/1224318#M61385 <P>Hey there,</P><P>It may not be the preferred workaround, but you could possibly address this by combining the two datasets and then running the Find Identical geoprocessing tool to find identical records based off both the fields you're comparing.&nbsp; Hope this helps!</P><P>-Derek Wood</P> Fri, 21 Oct 2022 17:08:04 GMT https://community.esri.com/t5/arcgis-pro-questions/find-matches-in-two-fields/m-p/1224318#M61385 drWood 2022-10-21T17:08:04Z https://community.esri.com/t5/arcgis-pro-questions/find-matches-in-two-fields/m-p/1224323#M61387 <P>Are you comfortable with Python? This would be fairly easy if you used <A href="https://pro.arcgis.com/en/pro-app/latest/arcpy/data-access/featureclasstonumpyarray.htm" target="_blank"><STRONG>FeatureClassToNumPyArray</STRONG></A> on each, then compare them that way.</P><P>See also: <A href="https://stackoverflow.com/questions/51352527/check-for-identical-rows-in-different-numpy-arrays" target="_blank">https://stackoverflow.com/questions/51352527/check-for-identical-rows-in-different-numpy-arrays</A></P> Fri, 21 Oct 2022 17:21:11 GMT https://community.esri.com/t5/arcgis-pro-questions/find-matches-in-two-fields/m-p/1224323#M61387 jcarlson 2022-10-21T17:21:11Z