I don't use python that often, so hopefully this hasn't been asked 100 times already. I have a python script created that already contains variables for two tables in a database. The current python below works fine, but I want to get rid of the paths that are in bold below and replace them with variables. I have tried deleting the paths and replacing them with the existing variables, but it doesn't appear to work. I get the correct number of rows added to the second table, but all of the attributes are NULL. This seems like it should be fairly straight forward, but everything I have tried seems to result in the empty output. I have tried several options like converting the parameters to strings use the ("%s%s") method but get the same null values. The only thing that seems to be working is including the full paths.
# Import arcpy module
import arcpy
# Local variables:
Path = "C:\\Users\\Username\\Documents\\ArcGIS\\Default.gdb"
SourceTable = Path + "\\SourceTable"
TargetTable = Path + "\\TargetTable"
# Process: Append
arcpy.Append_management(SourceTable, TargetTable, "NO_TEST", (
"Parcel_ID \"Parcel_ID\" true true false 50 Text 0 0 ,First,#,C:\\Users\\Username\\Documents\\ArcGIS\\Default.gdb\\SourceTable,Parcel_ID,-1,-1;"
"RoadType \"RoadType\" true true false 50 Text 0 0 ,First,#,C:\\Users\\Username\\Documents\\ArcGIS\\Default.gdb\\SourceTable,RoadType,-1,-1", "")
print "Process Finished"
CP modified code formatting
... View more