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.
Interesting. I just tried that and it worked for me, as well! ...hmmm
I am not having any issues joining the two layers together with the name fields. Are your students creating an in-map join, or running an actual geoprocessing tool? If the latter, do those students have a record selected when running the tool?
This is an online class, so I don't actually see them performing this. However, my guess is that they're using the Join tool from Contents - if that's what you mean by "in map"..?
Yes, you can join features just in a map, which is different from creating a join using a geoprocessing tool.
How is it different?
The output of Add Join is temporary, and can be removed without modifying the input tables. Join Field and Join Features can either alter the input or create a new output layer with the joined attributes / features. The latter two can also accidentally run on a subset of features if you have rows in either input selected when you run it.
...OK, but this is not the same tool. So, yes, we're only talking about doing an 'Add Join' -- whether you activate it from Contents or the Geoprocessing Toolbox
Right, so that's why I was checking. If it was the other two, then there could possibly be a simple explanation for the odd behavior. As it is, I can't really understand it. It works just fine over here, even without exporting it to a fresh file.
There is no FIPS code for the Standalone table. I misspoke a little that it was a "demographic" table. It is not; it is a table of Zika Mosquito Virus cases -- by State.