topic Re: Attribute table blank after exporting from successful table join in ArcGIS Pro in ArcGIS Pro Questions

Attribute table blank after exporting from successful table join in ArcGIS Pro

KathrynAngleton — Wed, 26 Feb 2020 22:54:03 GMT

Hi,

I did a table join in ArcGIS Pro of ACS Tiger data to block groups, turned off the fields I didn't want to keep, and exported the layer as a feature class in a gdb, then as a shapefile outside the gdb and both yielded blank attribute tables. Any idea why exporting keeps the fields but drops all the records?

Re: Attribute table blank after exporting from successful table join in ArcGIS Pro

DanPatterson_Retired — Wed, 26 Feb 2020 23:36:07 GMT

did you use

Copy Features—Data Management toolbox | Documentation

Feature Class to Feature Class—Conversion toolbox | Documentation

or some shortcut, that may not do what you want

Make sure you have no selections made unless you want to subset your inputs.

Re: Attribute table blank after exporting from successful table join in ArcGIS Pro

JamesHurdle — Thu, 27 Feb 2020 15:38:17 GMT

I am experiencing the same problem as the original poster of this question. I have just attempted both of your suggested tools, with no selections made. The results of both attempts yielded an attribute table with all the correct fields, but the data in fields that had come from the table I joined to the shapefile were set to 0.

Re: Attribute table blank after exporting from successful table join in ArcGIS Pro

DanPatterson_Retired — Thu, 27 Feb 2020 15:42:25 GMT

Then information will be required on the nature of the tables involved in the join. Was the join table a geodatabase table? Where did it come from.

Locally stored for both?

If the fields are coming over and the data are not, it leads me to think that the join table isn't up to par

Re: Attribute table blank after exporting from successful table join in ArcGIS Pro

JamesHurdle — Thu, 27 Feb 2020 15:49:41 GMT

The joined table originated in excel. I used excel to table tool to bring it into ArcPro. It is saved as a table in the project geodatabase. All the data is stored on a shared drive physically located a few rooms away on a server, but not locally to my computer.

What you say about the join not being up to par may be right. I have diagnosed the join as being the likely cause of other issues I am experiencing, of which I have a question related to these currently active.

Re: Attribute table blank after exporting from successful table join in ArcGIS Pro

DanPatterson_Retired — Thu, 27 Feb 2020 16:01:40 GMT

Bring everything to your local machine if you can. Recreate the excel-to-table table. Export the featureclass/table that you were using as the destination to a new copy first, preferably in a new, locally stored file geodatabase. This an attempt to isolate potential sources of problems. New test file gdb,. New featureclass, new excel derived table... everything local rules out a lot of potential sources of error

Re: Attribute table blank after exporting from successful table join in ArcGIS Pro

JamesHurdle — Thu, 27 Feb 2020 16:14:33 GMT

Thanks for the suggestion. I will bring everything over and test this.

Re: Attribute table blank after exporting from successful table join in ArcGIS Pro

KathrynAngleton — Thu, 27 Feb 2020 17:36:24 GMT

Dan, I did feature class to feature class. No features were selected upon export. I took the tables from the Census ACS detailed tables gdb and joined them to block groups. I then turned off the fields I didn't want (since there are so many) and tried to export with just the visible fields. The fields stayed, but the records dropped with all 0s.

Re: Attribute table blank after exporting from successful table join in ArcGIS Pro

KathrynAngleton — Thu, 27 Feb 2020 17:41:08 GMT

Here are images to show. First image is attribute table after the join and removing unwanted fields. Second is the shapefile that was exported after the join.

Re: Attribute table blank after exporting from successful table join in ArcGIS Pro

KathrynAngleton — Thu, 27 Feb 2020 18:04:24 GMT

Scratch that, for some strange reason, it's working now. Very strange how Esri products have been finicky all these years. It's amazing how waiting the next day or switching a computer will be the deciding factor on if a geoprocessing works or not.

Re: Attribute table blank after exporting from successful table join in ArcGIS Pro

DanPatterson_Retired — Thu, 27 Feb 2020 18:48:43 GMT

looks like they are for different areas within the featureclass and that '0' is a valid observation. Any chance that you sorted on a column or something? maybe the 0's will reappear if you do which means the data and join were fine yesterday