https://community.esri.com/t5/arcgis-pro-questions/spatial-join/m-p/1181660#M56042 <P>did you try the files in a file geodatabase rather than shapefiles?</P><P>The only issue I can find about "missing" is related to symbology, but since shapefiles don't support nulls (they become 0) it is hard to tell</P><P><A href="https://community.esri.com/t5/arcgis-pro-questions/missing-polygons-after-spatial-join/td-p/1124267" target="_blank">Solved: Missing Polygons after Spatial Join - Esri Community</A></P><P>So try gdb featureclasses rather than shapefiles would be my first suggestion</P> Thu, 09 Jun 2022 22:45:19 GMT DanPatterson 2022-06-09T22:45:19Z https://community.esri.com/t5/arcgis-pro-questions/spatial-join/m-p/1181648#M56038 <P>Is there a bug regarding the spatial join in ArcPRO?&nbsp; We tried to join a table of addresses with a table of zip codes. Below Zip 5 should have zip codes, instead it has zeros just like the ZIP5 column. Has anyone had this happen before? I tried it in Enterprise and it worked using the two same data sets. Very strange. Thank you for any input. Annette&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AnnettePoole1_0-1654811458291.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/43147i6C5D8C072E965EC2/image-size/medium?v=v2&amp;px=400" role="button" title="AnnettePoole1_0-1654811458291.png" alt="AnnettePoole1_0-1654811458291.png" /></span></P><P>&nbsp;</P> Thu, 09 Jun 2022 21:53:11 GMT https://community.esri.com/t5/arcgis-pro-questions/spatial-join/m-p/1181648#M56038 Anonymous User 2022-06-09T21:53:11Z https://community.esri.com/t5/arcgis-pro-questions/spatial-join/m-p/1181652#M56040 <P>Do you mean an attribute join? ( using common fields between 2 tables)&nbsp; Spatial joins use the geometry between two files.</P> Thu, 09 Jun 2022 22:17:09 GMT https://community.esri.com/t5/arcgis-pro-questions/spatial-join/m-p/1181652#M56040 DanPatterson 2022-06-09T22:17:09Z https://community.esri.com/t5/arcgis-pro-questions/spatial-join/m-p/1181653#M56041 <P>No, spatial join was used.&nbsp; We have points and then the polygon is the zip code shape file.</P> Thu, 09 Jun 2022 22:20:14 GMT https://community.esri.com/t5/arcgis-pro-questions/spatial-join/m-p/1181653#M56041 Anonymous User 2022-06-09T22:20:14Z https://community.esri.com/t5/arcgis-pro-questions/spatial-join/m-p/1181660#M56042 <P>did you try the files in a file geodatabase rather than shapefiles?</P><P>The only issue I can find about "missing" is related to symbology, but since shapefiles don't support nulls (they become 0) it is hard to tell</P><P><A href="https://community.esri.com/t5/arcgis-pro-questions/missing-polygons-after-spatial-join/td-p/1124267" target="_blank">Solved: Missing Polygons after Spatial Join - Esri Community</A></P><P>So try gdb featureclasses rather than shapefiles would be my first suggestion</P> Thu, 09 Jun 2022 22:45:19 GMT https://community.esri.com/t5/arcgis-pro-questions/spatial-join/m-p/1181660#M56042 DanPatterson 2022-06-09T22:45:19Z