I have a shape file of all the counties in the United States and data from the 208-2016 United States Presidential Elections. I am trying to join the data so that when I click on the county name, the results for the election will show. I have tried joining by the FIPS code but that doesn't help.
Here is the data if you think you can help me:
rather than post the large files, perhaps you can just do a screen grab of the two tables that show the fields you are trying to use in the join.
Covers most problems when people are trying to formulate joins
The Excel sheet name in your screenshot and the one attached to your original post, don't seem to be the same.
Anyway, as Dan mentioned, you need to make sure the fields you are joining, should have the same Data Type. The Esri Counties data, has FIPS as String(Text), however the one in the excel you show in the screenshot has Long Int. So that join won't work.
I added a new Column in the Counties Shapefile, FIPS_Num, populated the FIPS code in it from the existing FIPS Code field and that allows the join.
FYI -- Tip --
For those of you who do not know -- The first 8 Rows of an excel spreadsheet determines the datatype... so if you have rows of number but have one blank or text character within the first eight rows that column will be treated as text....in esri ...
I am using the 2010 population as a benchmark for whether a county is rural (2,499 or less), suburban (2500-49,999) and urban (50,000 or more). Is there a way in ARCGIS to make a formula that will automatically divide the counties up?