Only show me rows with a blank field

BigDataGeek

I'm looking to move a process out of excel if this would be more easily done in alteryx.

Each month we double check our data integrity for errors and blank fields.  I'm connecting to a sharepoint list and limiting the columns I look at.  From there, how could I spit out a report that only includes rows of data if they have any blank fields for the columns I selected?

Thanks

KaneG

Take a look at the attached.

Basically, select the fields to include > FieldInfo > Formula to wrap it in IsNull() > Summarize to concatenate > Manually copy the formula to the filter and tidy up.

Constructing large filter formula.yxmd