Select to view content in your preferred language

Arcgis Pro 3.1.3 Empty values when using Join Field

402
1
10-06-2023 02:34 AM
RobertStanionis
New Contributor II

Hello,

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.

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.

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?

0 Kudos
1 Reply
RobertStanionis
New Contributor II

I believe I have found the solution.

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!

0 Kudos