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!
