Joining Tables

892
2
01-16-2020 08:56 AM
AdrianBlevins
New Contributor III

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

0 Kudos
2 Replies
DanPatterson_Retired
MVP Emeritus

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

DarronPustam
Esri Contributor

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 

Darron
0 Kudos