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

Finde mehr Beiträge mit dem Tag

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.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Alle Communities
Neueste Beiträge
Gefolgter Inhalt
Community-Hilfe

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