topic Re: Domain Validation Blank Record Issue in ArcGIS Data Reviewer Questions

Domain Validation Blank Record Issue

StevenGraf1 — Fri, 06 Jun 2014 13:20:56 GMT

Running 10.2.2.

I run the Domain Validation check and it works correctly except it returns all records that don't have a specified domain. Is there a way to set the domain validation check to ignore empty/blank records?

Records can be empty in a domain if you load data into an existing domain field.

Thanks!

Re: Domain Validation Blank Record Issue

SteveSalas — Fri, 06 Jun 2014 14:29:44 GMT

By empty I think you mean an empty string that is not NULL? If that is the case, I think you need to ensure that all of those empty strings are converted to NULL prior to running this check. One or more space characters is probably being treated as just another text string that doesn't match a value in the coded value domain list. At least by converting them to NULLs, you have the toggle for "Search for Null Values" which you could use to ignore NULL values.

If your field does not allow NULL values, well, you're probably stuck adding a new value (to represent "unknown" or "not applicable") to both your data and the coded value domain.

Re: Domain Validation Blank Record Issue

StevenGraf1 — Fri, 06 Jun 2014 14:44:55 GMT

Ya, they are blank strings that were loaded into the domain field. I was hoping someone had developed a work around for this problem. Guess I will be creating a toolbox instead.

Thanks!

Re: Domain Validation Blank Record Issue

MichelleJohnson — Mon, 09 Jun 2014 20:43:51 GMT

Another option is to use the Execute SQL Check to validate fields with domains. You would have to enter in the complete list of valid domain values in your query, but you only have to do it once.