Can't compute census data difference between two shapefile layers

Discussion created by drdlund4 on Apr 10, 2013
Latest reply on Sep 21, 2015 by mducharme
I have census data by school district in two layers, each layer representing a point in time, five years apart. The layer is in a shape file. I would like to somehow compute the difference between the two census values for each school district and plot the five year change by district. I can't figure out how to do this. It seems like I should be able to join the two layers, but I keep getting this:

The number of matching records for the join:
- Unexpected error encountered.
- No matches found by joining [UNSDLEA10] from <201310_ot_district_totals> with [UNSDLEA10] from <200810_ot_district_totals>.

I've tried using several fields that should match, but get the same result. I do joins all the time and have never run into this problem.

The two layers are identical in every respect except for the "Count" which is the census data for the district.

The layers were created by joining census data from a spreadsheet to school district shape files, then exporting the resulting data to a shapefile. I am trying to join the shapefiles so that both "counts" appear in the same layer. At least then I should be able to compute a difference (I think).

I would appreciate it if anyone could throw me a bone (or some bread crumbs) re. this.