Hi all,

I am trying to transform the data from multiple excel files into a single activity table but while I am transforming the timestamp field. it shows the error below:

• Execution error: ERROR: Column "_EVENTTIME" is of type timestamp but expression is of type varchar

When I upload the file I have already indicated the field as DATETIME field 

Therefore i am not so sure about how this went wrong, appreciate your time and help in advance!