nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Append feature classes using Python

ejuser

I have 5 point feature classes that I am trying to append into a point feature class. I get the following error when I attempt to run the code shown below:

Failed to execute. Parameters are not valid.
ERROR 000338: Inputs must be either all Feature Classes, Tables or Rasters; not mixed.
Failed to execute (Append).

I can run the append successfully when using the Append tool in Desktop. I am at a loss as to why the code throws the error. Any insight would be very much appreciated.

# Import arcpy module
import arcpy
import os

SDE = r'C:\Development\py1\gis@GISDEV02 frt (emadb51 DC) - VegD2.sde'

# Set local variables
FC_Inven = os.path.join(SDE, 'GIS.VegD_Inventory')
FC_Unit = os.path.join(SDE, 'GIS.VegD_Unit_Inventory')
FC_Hrly2 = os.path.join(SDE, 'GIS.VegD_Hourly_Inventory')
FC_Hrly = os.path.join(SDE, 'GIS.VegD_Hourly')
FC_Flat = os.path.join(SDE, 'GIS.VegD_FlatRate')
FC_Matrix = os.path.join(SDE, 'GIS.VegD_Matrix')
schemaType = "NO_TEST"
fieldMappings = ""
subtype = ""

try:

# Process: Truncate Table
arcpy.TruncateTable_management(FC_Inven)

# Process: Append the feature classes into the empty feature class
arcpy.Append_management('FC_Unit; FC_Hrly2; FC_Hrly; FC_Flat; FC_Matrix', FC_Inven, schemaType, fieldMappings, subtype)

except Exception as err:
print(err.args[0])

Trouver plus de publications taguées avec

Accepted answers

ejuser

The error was caused by the Append input being interpreted as a string as opposed to variables. Below is syntax that worked for me. Thanks to all for your assistance with my issue!

arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'"'</SPAN> <SPAN class="operator token">+</SPAN> FC_Unit <SPAN class="operator token">+</SPAN> <SPAN class="string token">';'</SPAN> <SPAN class="operator token">+</SPAN> FC_Hrly2 <SPAN class="operator token">+</SPAN> <SPAN class="string token">';'</SPAN> <SPAN class="operator token">+</SPAN> FC_Hrly <SPAN class="operator token">+</SPAN> <SPAN class="string token">';'</SPAN> <SPAN class="operator token">+</SPAN> FC_Flat <SPAN class="operator token">+</SPAN> <SPAN class="string token">';'</SPAN> <SPAN class="operator token">+</SPAN> FC_Matrix <SPAN class="operator token">+</SPAN> <SPAN class="string token">'"'</SPAN><SPAN class="punctuation token">,</SPAN> FC_Inven<SPAN class="punctuation token">,</SPAN> schemaType<SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp;&nbsp; fieldMappings<SPAN class="punctuation token">,</SPAN> subtype<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

All comments

ejuser

The error was caused by the Append input being interpreted as a string as opposed to variables. Below is syntax that worked for me. Thanks to all for your assistance with my issue!

arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'"'</SPAN> <SPAN class="operator token">+</SPAN> FC_Unit <SPAN class="operator token">+</SPAN> <SPAN class="string token">';'</SPAN> <SPAN class="operator token">+</SPAN> FC_Hrly2 <SPAN class="operator token">+</SPAN> <SPAN class="string token">';'</SPAN> <SPAN class="operator token">+</SPAN> FC_Hrly <SPAN class="operator token">+</SPAN> <SPAN class="string token">';'</SPAN> <SPAN class="operator token">+</SPAN> FC_Flat <SPAN class="operator token">+</SPAN> <SPAN class="string token">';'</SPAN> <SPAN class="operator token">+</SPAN> FC_Matrix <SPAN class="operator token">+</SPAN> <SPAN class="string token">'"'</SPAN><SPAN class="punctuation token">,</SPAN> FC_Inven<SPAN class="punctuation token">,</SPAN> schemaType<SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp;&nbsp; fieldMappings<SPAN class="punctuation token">,</SPAN> subtype<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

DarrenWiens2

Ah, so it was. I thought you meant comma-delimited string. You can't make a list any other way

DanPatterson_Retired

perhaps there is some internal workings that handle the punctuation and spaces that isn't activated through arcpy calls to the tool directly

ejuser

I get the same ERROR 000338 when I copied the feature classes to a fgdb and modified the code to reference it and run it. I then tried using the Append tool and navigating to the fcs within the tool to add them with their entire fgdb path - it ran successfully. I went to the results, right-clicked and copied as code snippet. I took the input and target syntax from that code and replaced my append input and target parameters with it and ran the code - it worked successfully. I repeat these steps with a database connection and was successful.

arcpy.Append_management("'C:/Development/py1/gis@GISDEV02 frt (emadb51 DC) - VegD2.sde/GIS.VegD_FlatRate';'C:/Development/py1/gis@GISDEV02 frt (emadb51 DC) - VegD2.sde/GIS.VegD_Hourly';'C:/Development/py1/gis@GISDEV02 frt (emadb51 DC) - VegD2.sde/GIS.VegD_Matrix';'C:/Development/py1/gis@GISDEV02 frt (emadb51 DC) - VegD2.sde/GIS.VegD_Hourly_Inventory';'C:/Development/py1/gis@GISDEV02 frt (emadb51 DC) - VegD2.sde/GIS.VegD_Unit_Inventory'", "C:/Development/py1/gis@GISDEV02 frt (emadb51 DC) - VegD2.sde/GIS.VegD_Inventory", schemaType, fieldMappings, subtype)

I still don't know why when I attempt to clean this line of code up using variables, it results in the ERROR 000338.

DanPatterson_Retired

Darren... already suggested with not diff

https://community.esri.com/message/782971-re-append-feature-classes-using-python?commentID=782971#comment-782971

DarrenWiens2

The help example uses a list for the feature classes, not a delimited string.

Append—Data Management toolbox | ArcGIS Desktop

ejuser

I get the same error. I am going to copy the 6 feature classes into a fgdb and run the script on it to see if the error persists. Thanks for taking the time to offer some assistance.

bixb0012

Ah, sorry, forgot to wrap them in a list.

arcpy<SPAN class="">.</SPAN>Append_management<SPAN class="">(</SPAN> <SPAN class="">','</SPAN><SPAN class="">.</SPAN>join<SPAN class="">([</SPAN>FC_Unit<SPAN class="">,</SPAN> FC_Hrly2<SPAN class="">,</SPAN> FC_Hrly<SPAN class="">,</SPAN> FC_Flat<SPAN class="">,</SPAN> FC_Matrix]<SPAN class="">)</SPAN><SPAN class="">,</SPAN> FC_Inven<SPAN class="">,</SPAN> schemaType<SPAN class="">,</SPAN>&nbsp;&nbsp;&nbsp; fieldMappings<SPAN class="">,</SPAN> subtype<SPAN class="">)</SPAN>

ejuser

Unfortunately, I get the same error message when I try this approach as well.

ejuser

I tried this and got the following message in the python interpreter: join() takes exactly one argument (5 given)

Juan_ManuelAngel_Cuartas

Try to set the arcpy.env.workspace with the SDE path and just call the name of the FC in the list.

bixb0012

What about:

arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN> <SPAN class="string token">','</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>FC_Unit<SPAN class="punctuation token">,</SPAN> FC_Hrly2<SPAN class="punctuation token">,</SPAN> FC_Hrly<SPAN class="punctuation token">,</SPAN> FC_Flat<SPAN class="punctuation token">,</SPAN> FC_Matrix<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> FC_Inven<SPAN class="punctuation token">,</SPAN> schemaType<SPAN class="punctuation token">,</SPAN>&nbsp;&nbsp;&nbsp; fieldMappings<SPAN class="punctuation token">,</SPAN> subtype<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

ejuser

Thanks for the suggestion. I just tried a comma delimited list and got the same error message.

DanPatterson_Retired

have you tried a comma delimited list as inputs rather than a semi-colon delimited string?

The help isn't clear as to what is acceptable

http://pro.arcgis.com/en/pro-app/tool-reference/data-management/append.htm

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.