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

Question

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)

JoseSanchez · Answer

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)

DanPatterson_Retired · Answer

try the advice here

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

JoseSanchez · Answer

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