AnsweredAssumed Answered

Append feature classes using Python

Question asked by edward.glover_onegis on Jul 5, 2018
Latest reply on Jul 12, 2018 by edward.glover_onegis

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])

Outcomes