cfw2

Checking hundreds of fields for 'Null' values

Discussion created by cfw2 on Mar 8, 2011
Latest reply on Mar 11, 2011 by speaslee
I am running a script that selects one point at a time from a large point feature class in a file geodatabase, and extracts pixel values from an overlapping raster.  My raster has over 240 bands.  As the values are extracted, some will have 'Null' values while others won't.  Alternately, some points will extract ALL 'Null' values. 

Can anyone help me use an Update Cursor to say, "if all 240 fields are null, then delete the row".

The fields all end in a common suffix, "_val", so is there any way to use that as a wildcard?  "For all fields that end in "_val", if all values are Null, then delete the row?

Thank you!

Chris

Outcomes