Hello,
I have several students (but not all) who are attempting to do a very basic one-to-one join of US States with a simple Census demographic table, using the 'Name' field in each -- which of course is the State name. The result is only one match; Wyoming.
The data looks fine to me, and both 'Name' fields are "Text". However, I do notice that both of those are "indexed" as indicated by the asterisk (*).
See attached Geodatabase.
Could that be the problem? If not, what else should we check?
p.s. I tried to remove that index, but it didn't work, or I'm not doing it correctly
Thanks, Craig E.
Solved! Go to Solution.
Using the data that you provided as delivered, the joined fields were added but I got NULL values in all joined fields. I copied the feature class and table to another FGDB (Home) and Add Join worked correctly. Don't know why.
Interesting. I just tried that and it worked for me, as well! ...hmmm