I would like to create Python tool for deleting field using SQl Expression.
Can anyone suggest me.
Ok, Thanks.
If your trying to delete the values not the field then use a selection tool and then use field calculator to clear the fields.
Yes I am trying to delete the field values instead of field using SQl Statement.
This is my tool.
Yes, I had a look at the Delete Field code, Its is useful, Thanks.
This is my tool. When I click ok then the selected fields should only deleted.
code samples for query and delete are in the online help, just emulate
http://desktop.arcgis.com/en/desktop/latest/tools/data-management-toolbox/make-query-table.htm
I would like to make query builder to select records and delete that selected recods.
As Dan mentioned, there are code samples Delete Field—Help | ArcGIS for Desktop for deleting fields.
Are the Field names changing that require you to use a SQL statement for the field names? Or are you trying to query records and change the field value in the selected records? That would be a different process and I think would make more sense for using a query.
Did you look at the Delete Field code in the help?
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.