I need to join data from an Excel Spreadsheet to a Point feature class.
Namely, matching up Addresses from one piece of data to another, and then appending the rest of the data once the addresses match up.
The "Joins & Relates" tool worked fine, however, I was unable to specify how many characters should be considered a "Match" for the join.
I would like to be able to tell the tool that if 70% of all the characters match, or whatever, that should be considered a good match.
I apologize if my phrasing is off, but I hope I was able to get the point across.
I want to be able to specify what criteria a Join should look at.
I'm using ArcMap 10.2+.