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:
- 7/9/2019 1:24:30.897000 AM
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?