Joining Tables

Question

Hey, my issue is when I do a join of 2 features everything works just fine except when I look into the join attribute table I'm missing a lot of records so what went wrong? 1 table has 1008 records the other table has 1000 records but the joined table only has 897 records. Please help

DarronPustam · Answer

Hello Adrian - we have many places to go for expert help, this one's for ArcGIS Mission - you probably would get a quicker response posting these types of questions here Geodatabase

DanPatterson_Retired · Answer

There are some mismatches or one exists in one file but not the other.

The common glitches when joining text columns to text columns  are

* trailing or leading spaces
* column case (upper vs lower)
* special characters that may not be visible
* spaces in general

perhaps you could show some records that should have been a match but weren't