Find All Rows That Contain a Null or Empty Value in Any Field

[hellyars]

Question...

How can I check each row to find either an isnull() or isempty() value in any field (regardless of type) and then output those records?  ..I am looking for a simple solution vs. a brute force solution that I could pull together.

[Luke_C · Accepted solution]

Hi @hellyars 

Add a record ID, transpose the rest of the fields, and filter on the empty values. Isempty covers both empties and nulls.