nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

One-to-One Join by States only joining Wyoming

Craig_Eissler_Iceman

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.

zika_imapct.gdb.zip

Ke_Xu_1-1723796243370.png

Find more posts tagged with

Accepted answers

Craig_Eissler_Iceman

Interesting. I just tried that and it worked for me, as well! ...hmmm

All comments

jcarlson

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?

AdrianaAbramovich

Each state has a FIPS code in text format<>.
Adriana

BarryNorthey

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.

Craig_Eissler_Iceman

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"..?

jcarlson

Yes, you can join features just in a map, which is different from creating a join using a geoprocessing tool.

Craig_Eissler_Iceman

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.

Craig_Eissler_Iceman

How is it different?

Craig_Eissler_Iceman

Interesting. I just tried that and it worked for me, as well! ...hmmm

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.