https://community.esri.com/t5/arcgis-pro-questions/unsuccessful-zip-code-join-with-weather-data-csv/m-p/1155364#M53009 <P>I have a weather data set for 50 zip codes and I am trying to join to a zipcode polygon shp (I have tried TIGER and the Living Atlas feature in PRO). It does the join but all the weather data fields are Null. I have made sure the field name for the Zip fields are identical.&nbsp;</P> Fri, 18 Mar 2022 19:59:28 GMT MSherwood1 2022-03-18T19:59:28Z https://community.esri.com/t5/arcgis-pro-questions/unsuccessful-zip-code-join-with-weather-data-csv/m-p/1155364#M53009 <P>I have a weather data set for 50 zip codes and I am trying to join to a zipcode polygon shp (I have tried TIGER and the Living Atlas feature in PRO). It does the join but all the weather data fields are Null. I have made sure the field name for the Zip fields are identical.&nbsp;</P> Fri, 18 Mar 2022 19:59:28 GMT https://community.esri.com/t5/arcgis-pro-questions/unsuccessful-zip-code-join-with-weather-data-csv/m-p/1155364#M53009 MSherwood1 2022-03-18T19:59:28Z https://community.esri.com/t5/arcgis-pro-questions/unsuccessful-zip-code-join-with-weather-data-csv/m-p/1155367#M53010 <P>It isn't the field names that is important, it is the contents of the fields.&nbsp; You can join text to text, number to number, but the contents must match.&nbsp; For text, the case is important as well.&nbsp; For numbers, don't be fooled by left justified "numbers" they have probably been converted to their text representation.</P><P>Also, if there is no data for a particular match, the row will contain an empty (null) value</P> Fri, 18 Mar 2022 20:06:09 GMT https://community.esri.com/t5/arcgis-pro-questions/unsuccessful-zip-code-join-with-weather-data-csv/m-p/1155367#M53010 DanPatterson 2022-03-18T20:06:09Z