I am looking at the Prepare recipe, and trying to parse a column to date, but I have multiple date formats in the column. For example I have both:
I do not see that is is possible to have a Prepare recipe parse a column conditionally, e.g. check for format, then parse accordingly. It appears that I must pick one format to parse in. Is there any way to solve for this in the Prepare recipe?
You can specify multiple format in the preparation step of the parse date processor.