My spreadsheet contains a date/time format of dd mmm yy hh:mm:ss.
When I load it into Watson Analytics, the date is automatically separated into 3 different columns: one for day, one for month, and one for year. However, time remains locked into the full date/time cell. Is it possible to separate the time out from this column?
Also, how can I ensure the date and time are recognized as date and time. It would actually be better for me if everything remained together as one timestamp (including date) but I'm not sure this is possible. Does anyone have any ideas? Thanks!
#TRIRIGA#AssetandFacilitiesManagement