Correct time formats in a column (mm:ss to hh:mm:ss)

[47e38edcf5b72d47f353]

I have a column which has a mixture of values with hh;mm:ss and mm:ss time formats. Is there way of changing the rows that have the mm:ss format to match the hh:mm:ss format (i.e. add a 00: to the beginning of them?

[AMiller_Tri · Accepted solution]

Hi @Lee Gorringe? , thank you for your question.

In general, when there are multiple valid date formats in a column - Trifacta will be able to transform all the formats to the format of your choosing:

However, "mm:ss" isn't a valid date format, so you'll have to fix that manually. My way of choice would be using Trifacta pattern to add a prefix of "00:"

Pay attention, you'll need to use the {start} annotation so you'll capture only that portion.

Hope that makes sense.

Thanks,

Amit.