I'm on a time crunch or would read through and find the answer that certainly exist here. I want to join census tract to the excel file attached and nothing I am attempting is working. I did this 3 times with very similar files yesterday and no problem. Ive hit a wall and need some guidance. Thank you for taking the time.
I downloaded the Tiger shapefile and added a field to its table Census_Trc (double) calculated based on GEOID. The I added the same field (double) Census_Trc to the Meriden census table but abbreviated the GEOID number using Python script. Thus both have the Census_Trc field. I am not figuring out how to create a matching field on the crime table to base the final join on.
Wow, It worked but only captured 17/190 records. Just so happens that the Meriden census table has 17 rows. But the data joined matches correctly. Getting closer. Thank you so much. I still dont see how to get the rest but its an improvement. I might need to spit the crime table into sections of 17 rows? Seems convoluted but should work.