Hello, I have a table in a geodatabase where the value of a field is sometimes . How can I delete these rows? Thanks for your help! Best, Karsten

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Delete Rows where value is Null

KarstenRank

Hello,

I have a table in a geodatabase where the value of a field is sometimes <Null>. How can I delete these rows?

Thanks for your help!

Best,
Karsten

Vind meer berichten getagd met

Accepted answers

MarcinGasior

You have to provide valid SQL where clause and defined variable in getValue() function.
Here's an example:

import arcpy EingabeTabelle = r"C:\tmp\Test.gdb\YourTable" field = "Liste" whereClause = field + " IS NULL"  updCurs = arcpy.UpdateCursor(EingabeTabelle, whereClause) for row in updCurs:     if not row.getValue(field):         updCurs.deleteRow(row)

All comments

KarstenRank

Thank you! This solved my probl

Best,
Karsten

MarcinGasior

You have to provide valid SQL where clause and defined variable in getValue() function.
Here's an example:

import arcpy EingabeTabelle = r"C:\tmp\Test.gdb\YourTable" field = "Liste" whereClause = field + " IS NULL"  updCurs = arcpy.UpdateCursor(EingabeTabelle, whereClause) for row in updCurs:     if not row.getValue(field):         updCurs.deleteRow(row)

KarstenRank

If I insert the field name "Liste", I get the error message <type 'exceptions.NameError'>: name 'Liste' is not defined.[ATTACH=CONFIG]16269[/ATTACH]

up_curs = arcpy.UpdateCursor(EingabeTabelle,"Liste IS NULL")
for row in up_curs:
    if not row.getValue(Liste):
        row.deleteRow(row)

bild3.jpg

MathewCoyle

Off the top of my head I can think of two ways.

Option 1: Cursor

up_curs = arcpy.UpdateCursor(fc,"FIELD IS NULL")
for row in up_curs:
    if not row.getValue(FIELD):
        row.deleteRow(row)

Option 2: Select/Delete Features

arcpy.MakeFeatureLayer_management(fc,layer)
arcpy.SelectLayerByAttribute_management(layer,"FIELD IS NULL")
desc = arcpy.Describe(layer)

feat_count = int(arcpy.GetCount_management(parcel).getOutput(0))
feat_ids = desc.FIDSet

if feat_count > 0 and len(feat_ids) > 0:
    arcpy.DeleteFeatures_management(layer)

Note: I haven't tested either of these so make sure you do some trials in a test environment.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Alle Gemeenschappen
Recente Berichten
Gevolgde Inhoud
Community Hulp

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.