How to parse a column with multiple data formats

rtaylor
Level 3
How to parse a column with multiple data formats

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?

0 Kudos
1 Reply
Mattsco
Dataiker

Hi, 



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



Mattsco