Basic Census Join Problem

Question

I'm trying to join a census block shapefile, taken from here, with a census data table found here. The problem is the attribute tables don't align, in particular their GEOIDs. I've got no idea what to do, is it a problem with my data sources? Pictured below are the two hyperlinks, as well as the attribute tables from my two sources of data.

DavidPike · Answer

If there's no common field to match to or a logical way to create a common field e.g.

table 1 - GEOID000567

table 2 - 567

-> Create new calculated field for table 2 and then match against -> 'GEOID000' + [table2]

Other than manually adding a matching attribute then joining - you'll need to find a new polygon data source.  I would imagine there's many alternatives.

EthanGlaudemans · Answer

Definitely not, the census blocks I downloaded are for all of Texas while the census data is for Dallas County, so my idea was to clean the data if needed then do a join for the two so just the census blocks from dallas county would be joined + exported as a new file.

DanPatterson · Answer

not sure what is going on, but what I saw in your image was data from two separate geographic areas, which obviously isnt going to work