Select to view content in your preferred language

Joining Tables NULL?

645
3
11-25-2022 10:18 AM
SaulCardona
New Contributor

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. 

SaulCardona_0-1669399711340.png

SaulCardona_1-1669399886731.png

SaulCardona_2-1669399914753.png

 

 

Tags (4)
0 Kudos
3 Replies
SaulCardona
New Contributor

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

0 Kudos
DanPatterson
MVP Esteemed Contributor

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


... sort of retired...
0 Kudos
BarryNorthey
Frequent Contributor

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.

BarryNorthey_3-1669406886341.png

BarryNorthey_2-1669406836631.png

 

 

 

 

0 Kudos