topic Re: ArcGIS Pro Join between 2 feature classes not working in ArcGIS Pro Questions

ArcGIS Pro Join between 2 feature classes not working

LJackson29 — Thu, 17 Feb 2022 21:07:30 GMT

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)

When I try to join FC 2 to FC 1 (which I need to do to field calculate Parcel ID in FC 1 which has some changes that were made after Table 2 was created) only 115 out 1500 assets join
When I join in the opposite direction (FC 1 to FC 2) all 1500 assets join but I can't field calculate in FC 1
Perhaps notably, it was the last 115 records sorted by Asset_ID that joined.

I have tried everything I can think of that can cause problems when joining:

Both layers the Asset_ID is text with 15 characters
There are no duplicate Asset_IDs in either layer
Both layers have 1500 records
No definition queries on either layer
No records selected in either layer
I added indexes on Asset_ID to both layers
I added a new field in both layers (text, 15 characters) and field calculated Asset_ID and striped leading or trailing spaces (then no records would join!)
I updated from 2.8 to 2.9.1
I tried in ArcMap

Anyone have any suggestions? I am at a loss.

Thanks!

Leila

Re: ArcGIS Pro Join between 2 feature classes not working

DanPatterson — Thu, 17 Feb 2022 22:19:03 GMT

FC2 is a new featureclass with no joins? make sure joins are persisted to new featureclasses /or remove the joins

Re: ArcGIS Pro Join between 2 feature classes not working

MicZatorsky_AEC — Mon, 21 Feb 2022 03:09:44 GMT

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?

Re: ArcGIS Pro Join between 2 feature classes not working

LJackson29 — Mon, 21 Feb 2022 17:01:41 GMT

There are no joins on either layer. FC2 is a new layer created from a spatial join.