topic Re: How to Delete Fields from File Geodatabase Table using ArcPy in Python Questions

How to Delete Fields from File Geodatabase Table using ArcPy

JohnPapageorgiou — Mon, 23 Jan 2017 20:43:42 GMT

Hi,

I'm wondering if someone can help. I'm trying to write a python script that will:
1. Create a buffer
2. Use the buffer to query a feature class
3. Export a file geodatabase table of only the selected features
4. Delete unwanted fields
5. Export the cleaned up table to excel

Steps 1-3 work fine. I can even get that table to export to excel. I am having difficulty with step 4. I've tried various methods to do this but to no avail. Attached is a copy of the script. The Workspace, feature to buffer and proj_prefix are all input parameters not included in the snippet.

Thanks for any help in advance.

John

Re: How to Delete Fields from File Geodatabase Table using ArcPy

RebeccaStrauch__GISP — Mon, 23 Jan 2017 21:09:39 GMT

Hint: use https://community.esri.com/people/curtvprice/blog/2014/09/25/posting-code-blocks-in-the-new-geonet?sr=search&searchId=cb116ac2-10fd-404c-bd11-8ff900abd957&searchIndex=0‌ to make it easier for people to read you code and comment, versus having to open and view a snapshot.

If I understand correctly, you do not want to include some fields in the outputted Excel file. Try including the Fields you want to include using the Field Mapping. It is sometimes easier to run it manually first, then copy the python snippet from the results tab to see the format it wants.

Table To Table (Conversion)

TableToTable_conversion (in_rows, out_path, out_name, {where_clause}, {field_mapping}, {config_keyword})
Parameter Explanation

A couple other possibilities.....if your are trying to delete required fields or the file has a lock

Re: How to Delete Fields from File Geodatabase Table using ArcPy

DanPatterson_Retired — Mon, 23 Jan 2017 21:19:10 GMT

Delete Field—Help | ArcGIS Desktop

Are you sure the fields exist in the file you are creating? Case is important as well. you may need to add a check to see if the field exists prior to deleting it Field—Help | ArcGIS Desktop

Re: How to Delete Fields from File Geodatabase Table using ArcPy

JohnPapageorgiou — Mon, 23 Jan 2017 21:55:44 GMT

Hi Dan,

The fields are making it to the output table I create. Is that what you mean? Can you elaborate on "add a check", do you mean create a script that list the fields?

thanks,

John

Re: How to Delete Fields from File Geodatabase Table using ArcPy

JohnPapageorgiou — Mon, 23 Jan 2017 21:57:29 GMT

Hi Rebecca,

I'm looking into the field_mapping option right now. I'll keep your hint in mind for the next time I post a question.

thanks,

John

Re: How to Delete Fields from File Geodatabase Table using ArcPy

DanPatterson_Retired — Sat, 11 Dec 2021 10:22:22 GMT

You can get the field object and their names readily

field_names = [f.name for f in arcpy.ListFields(featureclass)]‍

Once you have those, you should check that the field names that you want to delete are actually there

How about an example to demonstrate what I mean

>>> del_flds = ["ArEa", "AREA", "Area", "NotArea"]
>>> fld_list = ["Area","length", "etc"]
>>> to_delete = [i for i in del_flds if i in fld_list]
>>> to_delete
['Area']‍‍‍‍‍

Then you can use the DeleteField Delete Field—Help | ArcGIS Desktop

Re: How to Delete Fields from File Geodatabase Table using ArcPy

FC_Basson — Tue, 24 Jan 2017 08:20:24 GMT

I think your problem lies in line 161 where you are defining the delete table - you are using the same syntax as for the TableToTable conversion tool, which is incorrect. I believe it should be

countyTable = "gis_data.gdb/" + proj_prefix + "_ca_counties"‍

Re: How to Delete Fields from File Geodatabase Table using ArcPy

JohnPapageorgiou — Tue, 24 Jan 2017 16:50:12 GMT

Thanks everyone for your contributions! FC Basson your suggestion solved the problem. Thank you so much!

Re: How to Delete Fields from File Geodatabase Table using ArcPy

DougHaller1 — Mon, 17 Jul 2017 17:30:31 GMT

Hi All,

I am working with a similar challenge.

Is there a way to keep the fields one wants rather than remove unwanted fields? If so, could one then create a table that is a subset of the original and save it to a new folder with a new name?

I will read about Field Mapping.

Also, would it be better to manage the fields when they are shapefiles or convert the .shp to a .xls first?

Thanks.

Doug