topic Re: When I open my map projects in ArcGIS Pro, the previously joined data is now all <null> in the attribute table in ArcGIS Pro Questions

When I open my map projects in ArcGIS Pro, the previously joined data is now all in the attribute table

Srygl1sl — Wed, 10 May 2023 18:39:54 GMT

I know that the join was successful and the data was not null in the past, because I have made and exported maps from this project file.

However, when I opened it today the attribute tables for all of my layers show the joined variables, but they are all populated with <null> as the value. What is causing this and how can I resolve it and prevent it with future projects?

Re: When I open my map projects in ArcGIS Pro, the previously joined data is now all in the attribute table

SLouq — Wed, 10 May 2023 18:42:43 GMT

were there any changes to your join field?

Re: When I open my map projects in ArcGIS Pro, the previously joined data is now all in the attribute table

MrRamonG — Wed, 10 May 2023 18:48:21 GMT

Were there any changes to the joined file, file name or file path?

Re: When I open my map projects in ArcGIS Pro, the previously joined data is now all in the attribute table

Srygl1sl — Wed, 10 May 2023 18:48:50 GMT

No- nothing has changed. I have a standalone table with the data I needed joined and nothing has been changed on that table. The data in that standalone table is also still fully populated. Only the attribute tables for all of my layers have the null values.

Re: When I open my map projects in ArcGIS Pro, the previously joined data is now all in the attribute table

Srygl1sl — Wed, 10 May 2023 18:52:23 GMT

Nope, no changes. The join is to a standalone table in the map contents and nothing has changed with it.

Re: When I open my map projects in ArcGIS Pro, the previously joined data is now all in the attribute table

SLouq — Wed, 10 May 2023 18:55:04 GMT

Have you checked the data type for each field? ArcGIS Pro could be interpreting one of the fields as a different data type

Re: When I open my map projects in ArcGIS Pro, the previously joined data is now all in the attribute table

DavidPike — Wed, 10 May 2023 18:55:20 GMT

Where is this standalone table located? Not sharepoint or cloud or anything?

Re: When I open my map projects in ArcGIS Pro, the previously joined data is now all in the attribute table

Srygl1sl — Wed, 10 May 2023 19:02:47 GMT

Apologies and correction.

The join is to an excel table. The location has not changed, nor has any of the content of the .xlsx. I have installed the drivers for using excel documents and had it working in the past in order to make these maps originally, but it appears that ArcGIS Pro is no longer connecting to excel files as when I went to select the .xlsx in my Catalog Pane I got the following error:

"exception of type 'ArcGIS.Desktop.Core.Geoprocessing.GPItemException"

Re: When I open my map projects in ArcGIS Pro, the previously joined data is now all in the attribute table

Srygl1sl — Wed, 10 May 2023 19:04:08 GMT

My mistake- it is joined to a .xlsx. Nothing about that file or its location has changed since the original maps were made and exported.

I have installed the drivers and had this connection working in the past, but it seems that Pro is no longer connecting to excel files. I got this error when I tried to select the relevant file in my Catalog Pane: "exception of type 'ArcGIS.Desktop.Core.Geoprocessing.GPItemException"

Re: When I open my map projects in ArcGIS Pro, the previously joined data is now all in the attribute table

SLouq — Wed, 10 May 2023 19:09:47 GMT

you should be able to access an Excel file from Pro. No drivers needed like in ArcMap. I can bring in Excel tables in Pro and perform a join. Have you tried right clicking and Display XY coordinates to make the Excel table a feature and then tried joining the tables?

Re: When I open my map projects in ArcGIS Pro, the previously joined data is now all in the attribute table

MrRamonG — Wed, 10 May 2023 19:15:50 GMT

I know it sounds strange, but in the past, when I was having ArcGIS problems with Excel files, I would open and close Microsoft Access and that would fix the issues. Opening Access would force the computer to install some updated database drivers.

Re: When I open my map projects in ArcGIS Pro, the previously joined data is now all in the attribute table

Srygl1sl — Wed, 10 May 2023 19:16:41 GMT

My workflow (shared with others) requires that the joins be to the file locations in the catalog folder connections- so bringing it in as a feature won't be a sustainable fix.

When I select the excel file in the catalog, it buffers, returns the error below an then I t a red exclamatin point beside it offering to "repair it". Selecting that option doesn't change anything. The error I get is: "exception of type 'ArcGIS.Desktop.Core.Geoprocessing.GPItemException"