Why doesn't Make Table View allow me to then Append the rows to a table

1997
4
05-23-2012 08:54 AM
HarryBowman
New Contributor III
Took a feature class and made a table view from its attribute table, using Make Table View.
Tried to use that table view as input to Append, to append to a table. Failed with Error 000573: The input and output must both be of the same type.

Why didn't this work? If it should not work for some reason (it looks as if it should), why did the Append tool let me try to run instead of flagging the error?
0 Kudos
4 Replies
markdenil
Regular Contributor II
Try writing the table out using CopyRows and then doing the Append.

Help for Append mentions that: "Input datasets can be point, line, or polygon feature classes, tables, rasters, raster catalogs, annotation feature classes, or dimensions feature classes." It does not mention transitory entities like Table Views or Layers.
0 Kudos
DrewFlater
Esri Contributor
This is a known issue with both the Append (management) and Merge (management) tools, which we will attempt to address as soon as possible -- you can follow the issue by using the identifier NIM081084. Both tools support table views and feature layers, but the bug prevents a table view made from a feature class from being appended or merged with a table. You can append or merge a table view made from a table with another table.

For the time being, the recommendation above to copy your table view to a temporary table using the Copy Rows (management) tool is the best solution. You can even copy to the in_memory workspace so that you don't have to consider cleaning up this intermediate data.

Regards,
Drew - Esri
0 Kudos
CharlesFried
New Contributor III
This is still a bug in 2013.  When will this be fixed?
0 Kudos
DrewFlater
Esri Contributor
The issue has been resolved in 10.1 Service Pack 1. You can read about SP1 and download it here
http://support.esri.com/en/downloads/patches-servicepacks/view/productid/160/metaid/1913#choose-prod...

Good luck!
Drew
0 Kudos