topic Re: Joining Tables NULL? in ArcGIS Pro Questions

Joining Tables NULL?

SaulCardona — Fri, 25 Nov 2022 18:18:07 GMT

I'm attempting to join two tables by NAME (per the instructions of the assignment). But when I do join them, the data of the second table appears as NULL. I don't understand what I'm doing incorrectly.

Re: Joining Tables NULL?

SaulCardona — Fri, 25 Nov 2022 18:46:53 GMT

Update, I did find that one state did appear in the joined table, the other still appear as Null

Re: Joining Tables NULL?

DanPatterson — Fri, 25 Nov 2022 19:03:35 GMT

There was a warning (yellow ! mark). What did it say?

Re: Joining Tables NULL?

BarryNorthey — Fri, 25 Nov 2022 20:12:34 GMT

Click the Validate Join button and check the message. See also the Add Join help for examples.

It is unlikely to be the problem but text in text fields can have invisible trailing (and leading) blank spaces. I have found this to be a problem on more than one occasion, even from "reliable" data sources. The following text string images look to be the same but the lower one has a trailing blank, which can be seen by clicking the mouse at the end of the text string. ArcGIS Pro sees them as different and no match will be made.