Detecting Full Null/Empty Rows for Review

[knobsdog]

I have several tables that load each morning and we need to review and make sure data has loaded into them.  I have tried to write a workflow that will pull out any rows that have all Null/Empty cells but when I try to run it it's pulling in all rows not just the null/empty rows.

Any ideas how I can get just the null/empty rows to show up in the final output.  I've been putting a Record ID on the rows and would like those records that have null/empty rows.  I can't share the actual workflow due to work privacy but the below example should pull back the 3rd row as not loaded.

  Car     Truck    Van

blue	red	green
red		yellow
blue	green

[Prometheus]

@knobsdog You can use the Data Cleansing tool and check the box next to "Remove null rows" and you'll get only the records that have at least one value in any field.

 

[binuacs]

@knobsdog based on my understanding I Created the below workflow

[flying008 · Accepted solution]

Hi, @knobsdog 

FYI.

[knobsdog]

The below 2 examples look like they're on the right track.  I have to go through them.  I'm not looking to remove the nulls I want to highlight when a null row occurs.  Thank you though.