Time Series: String to Date and Time Execution Failed

Hi there,
I used the column combiner node in order to regenerate my tamestamp after grouping.
In order to continue the time series analysis, I need to reformat the cell “Zeit unformatiert” as date.

The Error I get is “Execute failed: Failed to parse date in row 'Row0: Text ‘8:6:00’ could not be parsed at index 0”

Probably somebody alredy had the same error?
Thanks in advance and happy new year!

Hi @Veronika_Eder12

I am assuming Zeit Unformatiert should be a column of type time. You can manage this conversion by selecting this column in the string to date&time node and using a similar configuration to this one:


1 Like

Hi @ana_ved,
thanks for your quick answer.
Unfortunatelly this is where the error occurs

My guess is that there are empty spaces in your string somewhere. So instead of “08:01:00” you have something like "08:01:00 " or " 08:01:00 ", for instance. Can you use the string manipulation with something like removeChars(yourColumn, " ") and then see if the string to date and time works?


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.