Joining census data- keeps populating as null

07-05-2018 08:33 AM
New Contributor

I'm trying to join ACS data to a tiger line shapefile of block groups. Edited the file to get rid of periods, spaces, etc, and saved as a CSV, but when I join, the demographic data keeps showing up as null.

I've done some troubleshooting through previous threads, but nothing seems to be working. I don't really know how to use code, but if someone is able to break things down for a beginner, my instinct at this point is that the join is failing because the CSV data type doesn't match the shapefile data type...I included some pictures of things if that helps. 

(I couldn't get a picture, but the data type for the shapefile's GEOID is "Text (12)". 

Thank you! 

0 Kudos
0 Replies