AnsweredAssumed Answered

table join when the field is not exactly the same

Question asked by rqarvin on Nov 15, 2017
Latest reply on Nov 16, 2017 by rastrauch



I'm trying to join a feature class and an excel table by a field name is not exactly the same.


Our feature class has points named similar to this "XYZ 123", but the excel labels the field as "BM XYZ 123".


As you see they are very close to one another, but not exact. My department has a great amount of data to do this for that is why I was seeing if there is a script or a way to accomplish this.



Thank you very much!