How to parse a column with multiple data formats

rtaylor

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:

1. 7/9/2019 1:24:30.897000 AM
2. 2019-07-07-09.10.59.779000

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?

Mattsco

Hi,



You can specify multiple format in the preparation step of the parse date processor.