TRIRIGA

TRIRIGA

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  Help with date & time format in Watson analytics

    Posted Mon February 06, 2017 11:22 AM

    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


  • 2.  RE: Help with date & time format in Watson analytics

    Posted Wed February 08, 2017 12:22 PM

    I have used the excel "Text to Columns" function to break apart date-time fields.  Manual steps but it may help. 1- left justify, 2-make sure date time format is selected.  3) use "Text to Columns" manually delimit. 4) once excel pulls apart change date to MDY format.  If it has AM/PM make separate or not.  Import to WATSON ---- I hope I understand your need. ?  Jeff  301-405-3208    


    #AssetandFacilitiesManagement
    #TRIRIGA


  • 3.  RE: Help with date & time format in Watson analytics

    Posted Wed February 08, 2017 03:59 PM

    Hi Jeff, I just tried this and it did the trick! Thanks so much for you help! 


    #AssetandFacilitiesManagement
    #TRIRIGA


  • 4.  Help with date & time format in Watson analytics

    Posted Thu February 09, 2017 08:21 AM
    John, I will be talking to IBM Watson folks and will ask about it
    separating the hh:mm;ss .
    Jeff

    On Wed, Feb 8, 2017 at 3:58 PM, John V King
    #TRIRIGA
    #AssetandFacilitiesManagement


Related Content