topic Re: I am looking to find all fields that have all NULLs in a mxd and turn them off in Python Questions

I am looking to find all fields that have all NULLs in a mxd and turn them off

DanMacDonald — Fri, 11 Mar 2016 14:29:10 GMT

I this is the code I have tried so far

for lyr in arcpy.mapping.ListLayers(mxd):

... fields = arcpy.ListFields(lyr)

... for field in fields:

... rows = arcpy.SearchCursor(lyr,"","","","")

... for row in rows:

... for field in fields.keys():

... fields[field].append(row.getValue(field))

I am a newbie trying to get this to run any and all help would be appreciated

Thanks

DarrenWiens2 — Fri, 11 Mar 2016 17:19:13 GMT

Is there an error, or what is the problem? What version of ArcGIS are you on?

DanPatterson_Retired — Fri, 11 Mar 2016 17:35:04 GMT

Is there a need for this from an analysis perspective? Or is this just a preference on presentation?

If is the first, there are ways to handle nulls in data processing and analysis.