Unable to Convert to a Date and Time Format
I am importing data from a txt file. I have several columns that are timestamps. For example, the data is 20160421114552 - meaning 2016/04/21 11:45:52.
When I try to convert this to a date and time in Magic ETL, I select the column, put the new data type as "Date and Time", and select the format with "Year First". Yet when I preview, I keep getting the message that it "Failed to convert the data" (see attachment). I'm not sure where I'm going wrong here, but I need these to be timestamps as they are the date ranges for the data and I need to be able to select from them. What do I do?