Find Matches in Two Fields

Question

Hi all,

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?

Thanks in advance!

jcarlson · Answer

Are you comfortable with Python? This would be fairly easy if you used FeatureClassToNumPyArray on each, then compare them that way.

See also: https://stackoverflow.com/questions/51352527/check-for-identical-rows-in-different-numpy-arrays

drWood · Answer

Hey there,

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.  Hope this helps!

-Derek Wood