How to parse a column with multiple data formats

Registered Posts: 24 ✭✭✭✭✭

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?

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.