Incomplete Table Joins

BrandonGeorge2 — Thu, 02 Feb 2023 03:12:15 GMT

I'm trying to perform a table join in ArcGIS Pro 3.0.3, but am running into a very strange bug.

I have employment data at the census tract level that I am trying to aggregate to a higher scale neighborhood level feature class. I ran Tabulate Intersection using the two features, then summarized the result to get the sums of workers in each neighborhood.

However, when I try to join the table with those values back to the original neighborhood data it only joins part of them. That is, records with a neighborhood name past a certain point are joined while those with names earlier in the alphabet are not and have null values.

The key variable for the join was the name field, which was created by the Tabulate Intersection from the original feature and otherwise untouched, so the spellings and field type (both Text of length 64) are identical. Also, nothing was selected when the join was run.

Any suggestions would be appreciated!

Re: Incomplete Table Joins

JonathanNeal — Thu, 02 Feb 2023 03:26:54 GMT

That's weird. Have you tried Coping both data tables to a different fileGDB and retrying? I've seen table indexing get corrupted and do something like this.

Re: Incomplete Table Joins

DanPatterson — Thu, 02 Feb 2023 03:31:16 GMT

check for trailing spaces in the field names for the unjoined records, this was reported recently as a cause

topic Re: Incomplete Table Joins in ArcGIS Pro Questions

Incomplete Table Joins

Re: Incomplete Table Joins

Re: Incomplete Table Joins