Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

How do I capture values that are not recognized as dates?

Alteryx
Alteryx
Created

Question

How do I capture values that are not recognized as dates?  I am importing data from an Excel file.  Two of the fields are supposed to contain dates, but because the values are entered by hand sometimes they aren't entered in a way that is recognizable by Alteryx as a date.  For example, "11/8/`6" is entered instead of "11/8/16".  I want to divert the records that could not be read into a separate workflow.

Answer

Convert the date field first.  If the date does not convert, a NULL is produced.  Use a Filter Tool based on finding NULLs to create a separate stream:

 

 Dont_Convert.JPG

 

See v10.5 workflow attached.

Attachments
Comments
8 - Asteroid

Great catch. Thank you for sharing!