0 votes

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?

by

1 Answer

+1 vote

Hi, 

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

by
1,322 questions
1,342 answers
1,543 comments
11,891 users

©Dataiku 2012-2018 - Privacy Policy