Mark Records with Certain or Missing Data for Review

[laurenn]

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.  

[MarqueeCrew]

@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

[laurenn]

Thank you!

[Qiu]

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