String to date/time in csv file

KNIME Analytics Platform
1

I'm new in Knime and want to transform a string to a date/time format, but after running it says 'rows could not be converted'

I dont see why? The steps I did were:

- Read the file with CSV reader;

- Use Math Formula to create a new index (instead of timestamp)

- Use RowID to generate a new column;

- Use String to Date&Time, but this one fails.

See example with the csv file. Can someone help me with this?

2

you need to adapt the dateformat to the existing format in your table..
so put yyyyMMddHHmmss in the string to date node.. DONE

3

Thanks for your reply, it is working now