topic Re: Joining Tables in ArcGIS Mission Questions https://community.esri.com/t5/arcgis-mission-questions/joining-tables/m-p/287225#M2 <HTML><HEAD></HEAD><BODY><P>There are some mismatches or one exists in one file but not the other.</P><P>The common glitches when joining text columns to text columns&nbsp; are</P><UL><LI>trailing or leading spaces</LI><LI>column case (upper vs lower)</LI><LI>special characters that may not be visible</LI><LI>spaces in general</LI></UL><P>perhaps you could show some records that should have been a match but weren't</P></BODY></HTML> Thu, 16 Jan 2020 17:17:51 GMT DanPatterson_Retired 2020-01-16T17:17:51Z Joining Tables https://community.esri.com/t5/arcgis-mission-questions/joining-tables/m-p/287224#M1 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Thu, 16 Jan 2020 16:56:11 GMT https://community.esri.com/t5/arcgis-mission-questions/joining-tables/m-p/287224#M1 AdrianBlevins 2020-01-16T16:56:11Z Re: Joining Tables https://community.esri.com/t5/arcgis-mission-questions/joining-tables/m-p/287225#M2 <HTML><HEAD></HEAD><BODY><P>There are some mismatches or one exists in one file but not the other.</P><P>The common glitches when joining text columns to text columns&nbsp; are</P><UL><LI>trailing or leading spaces</LI><LI>column case (upper vs lower)</LI><LI>special characters that may not be visible</LI><LI>spaces in general</LI></UL><P>perhaps you could show some records that should have been a match but weren't</P></BODY></HTML> Thu, 16 Jan 2020 17:17:51 GMT https://community.esri.com/t5/arcgis-mission-questions/joining-tables/m-p/287225#M2 DanPatterson_Retired 2020-01-16T17:17:51Z Re: Joining Tables https://community.esri.com/t5/arcgis-mission-questions/joining-tables/m-p/287226#M3 <HTML><HEAD></HEAD><BODY><P>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 <A _jive_internal="true" class="" href="https://community.esri.com/groups/geodatabase/activity">Geodatabase</A>&nbsp;</P></BODY></HTML> Thu, 25 Jun 2020 22:40:32 GMT https://community.esri.com/t5/arcgis-mission-questions/joining-tables/m-p/287226#M3 DarronPustam 2020-06-25T22:40:32Z