topic Re: Data Reviewer: Best practices for identifying null values in attribute tables? in ArcGIS Data Reviewer Questions

Data Reviewer: Best practices for identifying null values in attribute tables?

AshleyMott — Tue, 15 Mar 2011 15:10:24 GMT

Hi everyone,
I am just diving into Data Reviewer. Totally new stuff for me.

Anyway, I would like to identify null values for all of my fields in every feature class in a geodatabase. Is there an easy way to do this? I have attempted to test the "Null Values Check" in "Regular Expression Check Properties" in "Table Checks" with no success.

Any suggestions would be greatly appreciated.

Ashley

Re: Data Reviewer: Best practices for identifying null values in attribute tables?

MichelleJohnson — Tue, 15 Mar 2011 15:17:51 GMT

Use the Execute SQL check to find NULL values in fields. You can create a check for each field you want to validate or one check that includes all fields.

Re: Data Reviewer: Best practices for identifying null values in attribute tables?

AshleyMott — Tue, 15 Mar 2011 15:58:45 GMT

Thanks Michelle!

Is there a faster way to query than FIELD1 = 'NULL' OR FIELD2 = 'NULL' and on and on? I have dozens of fields in each feature class and over 100 feature classes.

Re: Data Reviewer: Best practices for identifying null values in attribute tables?

KumarBhardwaj — Tue, 15 Mar 2011 17:29:56 GMT

One option is to create a batch job and use Duplicate Check functionality if you have common fields in different feature classes in database or else you have to edit the individual check.

For more detail about Duplicating checks in batch job refer to the following web help URL:

Duplicating checks in batch jobs
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Duplicating_checks_in_batch_jobs/010200000053000000/

Re: Data Reviewer: Best practices for identifying null values in attribute tables?

AshleyMott — Tue, 15 Mar 2011 19:40:25 GMT

Thanks Kumar!

Although, that may not help me so much with my null values check, that helps me immensely with the geometry checks I have to create. :cool:

Re: Data Reviewer: Best practices for identifying null values in attribute tables?

adineuman — Mon, 11 Jul 2011 07:58:45 GMT

Hi,

I'm new with the Data Reviewer too. I use the Domain Value Check for searching for Null values. But be aware that if you have more than 20K errors, it will crash.

Adi

Re: Data Reviewer: Best practices for identifying null values in attribute tables?

MichelleJohnson — Tue, 12 Jul 2011 18:35:30 GMT

If you suspect there may be more than 20K records being returned, be sure to close the reviewer table before running the check or batch job. That should help prevent crashes from occurring when lots of errors are being written to the Reviewer table.