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 | |
