Losing data in table join

DylanHamel

Hello GIS community,

I have an excel table of data that includes columns with a race heading along with percentages of that race per school district. For some reason, there an was error (as seen below) where the American Indian column outputs as null for all values not 0. Why could this be the case? Originally, the American Indian column had a space, but I corrected for that (American_Indian), resaved in a different file, and still the same error came up.

Thanks for your help guys!

DarrenWiens2

Curious. I was about to tell you that you must be doing something wrong, but I can replicate what you're seeing (mostly).

1.) Create CSV with space in field name.

2.) Add CSV to ArcMap.

3.) Attempt join. Validation produces the error above.

4.) Remove CSV from ArcMap.

5.) Remove space from CSV field name outside ArcGIS.

6.) Save over original CSV.

7.) Add CSV to ArcMap, again.

8.) Inspect CSV table - looks good, no space.

9.) Attempt join. Still greeted by error on join validation.

I think this must be a bug of some sort. I'm not sure if the CSV file is kept in memory in some way.

Anyhow, a workaround is to close ArcMap, reopen ArcMap, and join with the fixed CSV. Or, save CSV to new file, but it sounds like you did this. Saving to new file works for me.