topic ArcGIS Pro 2.6 - Table to Table tool issue in ArcGIS Pro Questions

ArcGIS Pro 2.6 - Table to Table tool issue

StephenRetallack2 — Tue, 04 Aug 2020 05:46:04 GMT

Hi,

Since I have updated to ArcGIS Pro 2.6, the Table to Table tool doesn't seem to work properly. It strips all the output fields except for objectid. Plus, most of the time, the output fields tab is inaccessible to configure the output.

Any else have this problem?

Thanks

Re: ArcGIS Pro 2.6 - Table to Table tool issue

Robert_LeClair — Wed, 05 Aug 2020 15:49:44 GMT

Using ArcGIS Pro 2.6, I tested the Table to Table GP tool and none of my fields are being stripped out. Try this - create a copy of the table to export. Run the Table to Table GP tool on the new exported copy. What is the result? Please advise.

Re: ArcGIS Pro 2.6 - Table to Table tool issue

Juan_FelipeVillegas — Wed, 05 Aug 2020 18:34:40 GMT

I have the same issue after updating arcgis pro to version 2.6

Re: ArcGIS Pro 2.6 - Table to Table tool issue

Robert_LeClair — Wed, 05 Aug 2020 20:49:41 GMT

With your AGP 2.6 was it a clean install meaning completely uninstalling 2.5 followed by a new install of AGP 2.6? This is what I did and no issues related to this item. What is the table format? GDB? Excel? CSV? Etc.?

Re: ArcGIS Pro 2.6 - Table to Table tool issue

Juan_FelipeVillegas — Wed, 05 Aug 2020 21:30:36 GMT

The installation was not clean, I will try to install AGP 2.6 again. The table format was from GDB to csv.

Re: ArcGIS Pro 2.6 - Table to Table tool issue

StephenRetallack2 — Wed, 05 Aug 2020 23:29:29 GMT

Hi Robert,

This didn’t work. Same result and the fields are not available to manipulate. I’m using the table to table tool on tables inside a file gdb. Also, tried from egdb (SQL Server) to fgdb.

No to clean install. I always choose the update option.

I too will try a clean install.

Thanks

Re: ArcGIS Pro 2.6 - Table to Table tool issue

Juan_FelipeVillegas — Thu, 06 Aug 2020 00:02:42 GMT

I did a clean installation and the problem is the same. The output table has just the Value and the counts of the raster, the other fields of the table are missing.

I tried with the same tool in arcgis desktop 10.8 and the tool works without problems.

Re: ArcGIS Pro 2.6 - Table to Table tool issue

StephenRetallack2 — Thu, 06 Aug 2020 00:41:06 GMT

Hi Robert,

A clean installation worked for me.

Thanks

Re: ArcGIS Pro 2.6 - Table to Table tool issue

Robert_LeClair — Thu, 06 Aug 2020 15:17:08 GMT

Is the raster dataset a floating point or integer? That could explain field issues perhaps.

Re: ArcGIS Pro 2.6 - Table to Table tool issue

AngelaDeegan — Tue, 15 Sep 2020 18:12:14 GMT

I'm having a problem with Table to Table in Pro 2.6 also. It's only working for tables - not for Feature Classes, even though Table to Table is the tool that's automatically used when you choose to Export a feature class.

I went to Pro 2.6.1 thinking that might solve the problem but it didn't. I don't have an expression defined in my Table to Table run, but I keep getting 'Error 160912: Failed to evaluate Arcade expression'.

I guess I'll try re-installing to see if that fixes this issue.

Re: ArcGIS Pro 2.6 - Table to Table tool issue

DrewFlater — Wed, 16 Sep 2020 19:49:53 GMT

I just tested exporting a simple integer raster with several field types to an output csv using Table To Table in ArcGIS Pro 2.6.1. It completed successfully and the csv has the fields and values I expect. Can you share the raster you are having this issue with?

Re: ArcGIS Pro 2.6 - Table to Table tool issue

DrewFlater — Wed, 16 Sep 2020 19:51:28 GMT

Angela Deegan‌ I just tested using Table To Table with an input feature class (from file gdb) which has an assortment of field types. The table export completed successfully for both file gdb output as well as csv. Can you share the feature class where you are seeing this problem?

Re: ArcGIS Pro 2.6 - Table to Table tool issue

AngelaDeegan — Wed, 16 Sep 2020 20:52:07 GMT

The feature classes we've tried this with are in our enterprise geodatabase (on Postgres 10.12 on Linux). My colleague confirmed he's having the issue too. Our feature classes do have attributes rules on them, by the way, so I'm not sure if that's a factor.

How should I share the data with you? I guess I'd need to export them to file geodatabase?

Re: ArcGIS Pro 2.6 - Table to Table tool issue

DrewFlater — Wed, 16 Sep 2020 21:00:40 GMT

Angela Deegan‌ yes please try to make a file gdb copy. When you have the file gdb copy you can also check if the same problematic behavior occurs with file gdb input to Table To Table.

Re: ArcGIS Pro 2.6 - Table to Table tool issue

AngelaDeegan — Wed, 16 Sep 2020 21:10:54 GMT

I was able to export a feature class to file geodatabase. When should I upload it for you?

Re: ArcGIS Pro 2.6 - Table to Table tool issue

DrewFlater — Wed, 16 Sep 2020 22:29:22 GMT

Angela Deegan‌ please zip the file gdb and email to dflater@esri.com. Thanks!

Re: ArcGIS Pro 2.6 - Table to Table tool issue

AngelaDeegan — Wed, 16 Sep 2020 22:44:38 GMT

I just now emailed it to you, Drew.

Re: ArcGIS Pro 2.6 - Table to Table tool issue

Juan_FelipeVillegas — Fri, 11 Dec 2020 15:08:36 GMT

The raster dataset is of integer data type. The attribute table of the raster has the fields "OBJECTID*", "Value", and "Count". When using the Table To Table tool im just getting a field named "OID_".

I already tried to export the attribute table to csv, txt with the same problem.

A clean installation of Arcgis Pro 2.6 was already done as well without solving the problem. I'm getting the same problem with multiple rasters.

Attached you will find one of the rasters.