https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-3-1-3-empty-values-when-using-join/m-p/1335722#M73772 <P>I believe I have found the solution.</P><P>I created joins on the stand alone table that has my main dataset with the other stand alone tables that have the URLs. Then I exported the main table and ran 'Display X/Y' on the main table. Saved and closed the project and reopened it and the process still works!</P> Fri, 06 Oct 2023 11:10:25 GMT RobertStanionis 2023-10-06T11:10:25Z https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-3-1-3-empty-values-when-using-join/m-p/1335711#M73771 <P>Hello,</P><P>In previous version of Arc Pro I would use the Join Field Data Tool to grab a URL from a SQL database and create a column in a layer based on the report number of the row/record. This worked well until 3.1.0. Now, when I use the Join Field tool it completes successfully but for rows that have a URL in the 'press_release' column the cell is empty not null.</P><P>I have tried joining the layer and the query and then calculating the fields. This works but only manually if I recreate the calculation. I can not use the previous step in the History tab.</P><P>Does anyone know how to get the Join Field tool to work correctly again or a way to get the calculated fields option to work so that I can automate the process using python?</P> Fri, 06 Oct 2023 09:34:55 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-3-1-3-empty-values-when-using-join/m-p/1335711#M73771 RobertStanionis 2023-10-06T09:34:55Z https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-3-1-3-empty-values-when-using-join/m-p/1335722#M73772 <P>I believe I have found the solution.</P><P>I created joins on the stand alone table that has my main dataset with the other stand alone tables that have the URLs. Then I exported the main table and ran 'Display X/Y' on the main table. Saved and closed the project and reopened it and the process still works!</P> Fri, 06 Oct 2023 11:10:25 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-pro-3-1-3-empty-values-when-using-join/m-p/1335722#M73772 RobertStanionis 2023-10-06T11:10:25Z