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!
Veronika
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:
Cheers,
Ana
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.
