MATLAB: Converting table 2 timetable using timeVarName

table2timetable

Hi,
As the title sugguests I am trying to convert a table (originally from excel) to a time table. I'm trying to use a specific variable for RowTimes. I get the error message "row times must be datetime or duration vector".
How to a "convertor" a specfic variable to a duration vector in my original table or during data import?. Variable I want to use is a simple timestamp in seconds ( a recorder time from data acqusition software).
Thanks

Best Answer

A = array2table(magic(4))
A = 4x4 table
    Var1    Var2    Var3    Var4
    ____    ____    ____    ____

     16       2       3      13 
      5      11      10       8 
      9       7       6      12 
      4      14      15       1 

T = table2timetable(A, 'RowTimes', seconds(A.Var1))
T = 4x4 timetable
     Time     Var1    Var2    Var3    Var4
    ______    ____    ____    ____    ____

    16 sec     16       2       3      13 
    5 sec       5      11      10       8 
    9 sec       9       7       6      12 
    4 sec       4      14      15       1
You'd probably want to remove Var1 from T if you do this.
T2 = table2timetable(A(:, 2:4), 'RowTimes', seconds(A.Var1))
T2 = 4x3 timetable
     Time     Var2    Var3    Var4
    ______    ____    ____    ____

    16 sec      2       3      13 
    5 sec      11      10       8 
    9 sec       7       6      12 
    4 sec      14      15       1
Related Question