Mark Records with Certain or Missing Data for Review

Question

Hello,

I am working with data in Alteryx and need to mark records that contain vendor notes (in the a field titled vendor notes) for review.  I also have to mark for review records with missing vendor name, city or state for those respective fields and was wondering the best way to do this? Thank you.

Qiu · Answer

@laurenn 
If you could provide some sample input and desired output, many persons here would be happy to provide more detailed help.

laurenn · Answer

Thank you!

MarqueeCrew · Answer

@laurenn ,

One option is to flag each field with a Boolean (true or false) and put that answer into its own field (as one record could be missing many values).  If you just want those records t could be a filter on IsEmpty([field1]) or isempty([field2]) etcetera.

many ways to skin this challenge.

cheers,

mark