I am trying to join two Point feature classes (FC) on Asset ID (Text, 15 characters):
FC 1 (Main table): Asset_ID
FC 2 was created doing a spatial join between FC 1 and a parcel layer (Asset_ID that was from FC 1)
I have tried everything I can think of that can cause problems when joining:
Anyone have any suggestions? I am at a loss.
FC2 is a new featureclass with no joins? make sure joins are persisted to new featureclasses /or remove the joins
There are no joins on either layer. FC2 is a new layer created from a spatial join.
I had the same issue recently. My primary key was long string, which only worked on a join in one direction. I worked around it at the time by creating a numeric surrogate key in each table and joining on that and it worked. I've since read that the failure to join may have been affected by the index? It may be worth removing and re-adding the index on the keys and see if that makes a difference?