topic Re: arcpy.Append_management how to match from/to fields with different names in Python Questions

arcpy.Append_management how to match from/to fields with different names

JoseSanchez — Tue, 25 Jun 2019 17:51:01 GMT

Hello

How do I match FCFrom field "Point_X" with FCTo field "PointX" before doing an arcpy.Append_management

# Create a new fieldmappings and add the two feature classes.
    fieldmappings = arcpy.FieldMappings()
    fieldmappings.addTable(FCFrom)
    fieldmappings.addTable(FCTo)
    schemaType = "NO_TEST "

???? how do I match FCFrom field "Point_X" with FCTo field "PointX"

arcpy.Append_management(FCFrom, FCTo, schemaType, fieldMappings, subtype)

Re: arcpy.Append_management how to match from/to fields with different names

DanPatterson_Retired — Tue, 25 Jun 2019 17:53:28 GMT

see the code example on field mapping here

Mapping input fields to output fields—ArcPy Get Started | ArcGIS Desktop

Re: arcpy.Append_management how to match from/to fields with different names

JoseSanchez — Tue, 25 Jun 2019 19:41:35 GMT

I want to populate the field CAPDESC with the field "CAP_DESC" .

What am I missing?

I am getting this error message :

ERROR 000800: The value is not a member of TEST | NO_TEST.

Create a new fieldmappings and add the two feature classes.
    fieldmappings = arcpy.FieldMappings()
    fieldmappings.addTable(FCFrom)
    fieldmappings.addTable(FCTo)
    schemaType = "NO_TEST "

fieldmappings.replaceFieldMap(fieldmappings.findFieldMapIndex("CAPDESC"), fieldmap)
fieldmap.addInputField(FCFrom, "CAP_DESC")
fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("CAP_DESC"))

arcpy.Append_management(FCFrom, FCTo, schemaType, fieldmappings)

Re: arcpy.Append_management how to match from/to fields with different names

DanPatterson_Retired — Tue, 25 Jun 2019 19:54:59 GMT

Jose, you have use "CAPDESC" 3 times, in the code example they used the sequence "TRACT2000", "TRACTCODE", "TRACT2000"

Code with line numbers would help

/blogs/dan_patterson/2016/08/14/script-formatting

Re: arcpy.Append_management how to match from/to fields with different names

JoseSanchez — Tue, 25 Jun 2019 20:01:06 GMT

Changed the code:

   fieldmap = fieldmappings.getFieldMap(fieldmappings.findFieldMapIndex("CAPDESC"))
    fieldmap.addInputField(FCFrom, "CAP_DESC")
    fieldmappings.replaceFieldMap(fieldmappings.findFieldMapIndex("CAPDESC"), fieldmap)
    fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("CAP_DESC"))

Same error:

Failed to execute. Parameters are not valid.

ERROR 000800: The value is not a member of TEST | NO_TEST.

Failed to execute (Append).

Re: arcpy.Append_management how to match from/to fields with different names

DanPatterson_Retired — Tue, 25 Jun 2019 20:33:25 GMT

try the advice here

https://community.esri.com/thread/214904-field-mappings-variable-as-a-parameter-not-working-in-1051

Re: arcpy.Append_management how to match from/to fields with different names

JoseSanchez — Wed, 26 Jun 2019 16:56:41 GMT

Finally I found the error: in the variable schemaType = "NO_TEST " the string "NO_TEST " had a space at the end. I removed the space schemaType = "NO_TEST", and now it works.

#Target Layer
    fieldmappings.addTable(FCto)
    #Append Layer
    fieldmappings.addTable(FCFrom)

schemaType = "NO_TEST"

fieldmap = fieldmappings.getFieldMap(fieldmappings.findFieldMapIndex("CAPDESC"))

    fieldmap.addInputField(FCFrom, "CAP_DESC")
    fieldmappings.replaceFieldMap(fieldmappings.findFieldMapIndex("CAPDESC"), fieldmap)

arcpy.Append_management(FCFrom, FCto, schemaType, fieldmappings)