FieldMappings: Error in removing a field map from field mappings for RemoveFieldMap

ZdeněkSoldán

Hi

I have a layer named patro_join with 114 fields and I want to preserve only two fields ("Layer","Text") in this layer. I tried to use FieldMappings but it removed only a half of fields and 57 fields still stay in the layer. I don´t know what is wrong. Here is my part of code:

fieldmappings = arcpy.FieldMappings()

fieldmappings.addTable("patro_join")

i=0

for field in fields:

      if field.getInputFieldName(0) == "Layer":

           print field.getInputFieldName(0)

     elif field.getInputFieldName(0) == "Text":

           print field.getInputFieldName(0)

     else:

           print field.getInputFieldName(0)

           fieldmappings.removeFieldMap(i)

           i=i+1

Can anyone help me please?

RebeccaStrauch__GISP

If you only want to preserve a few fields, why don't you use the "Feature Class to Feature class" tool and only include the two fields you want to keep.   Feature Class To Feature Class—Help | ArcGIS for Desktop    This seems simpler than trying to delete a bunch of fields.

You can run a test manually to get the format of the fields you need to keep (if you have to do this multiple times, so you need it in a script).

Here's a sample...

tool, before the delete....will delete all but PtID and the two elev_ fields

my new featureclass....

The "code snippet" from the results tab....

arcpy.FeatureClassToFeatureClass_conversion(in_features="C:/_beartest/Prep.gdb/Pts1_dd", out_path="C:/_beartest/Prep.gdb", out_name="testoutput", where_clause="", field_mapping="""PtID "Ptno" true true false 2 Short 0 0 ,First,#,C:\_beartest\Prep.gdb\Pts1_dd,PtID,-1,-1;elev_ft "elev_ft" true true false 2 Short 0 0 ,First,#,C:\_beartest\Prep.gdb\Pts1_dd,elev_ft,-1,-1;elev_m "elev_m" true true false 2 Short 0 0 ,First,#,C:\_beartest\Prep.gdb\Pts1_dd,elev_m,-1,-1""", config_keyword="")

....since the formatted snippet is off the screen...I'll include it as just the text.  Of course, you do not need the "fieldname=" in each of the arguments....

arcpy.FeatureClassToFeatureClass_conversion(in_features="C:/_beartest/Prep.gdb/Pts1_dd", out_path="C:/_beartest/Prep.gdb", out_name="testoutput", where_clause="", field_mapping="""PtID "Ptno" true true false 2 Short 0 0 ,First,#,C:\_beartest\Prep.gdb\Pts1_dd,PtID,-1,-1;elev_ft "elev_ft" true true false 2 Short 0 0 ,First,#,C:\_beartest\Prep.gdb\Pts1_dd,elev_ft,-1,-1;elev_m "elev_m" true true false 2 Short 0 0 ,First,#,C:\_beartest\Prep.gdb\Pts1_dd,elev_m,-1,-1""", config_keyword="")

Sometimes you just need to sit back and see if there is a simpler way.  Hope this helps.