MATLAB Answers

Add timetable with many months to another timetable with few months

2 views (last 30 days)
Martin
Martin on 13 Sep 2019
Commented: Martin on 13 Sep 2019
I have two time tables like this:
cars =
1×1 timetable
Time Cars
________ ________
Sep-2019 42
and
bus =
1×1 timetable
Time buses
________ _______
Aug-2019 12
Sep-2019 54
Then I need to add the bottom table to the top table like this:
cars =
1×2 timetable
Time Cars buses
________ ________ _______
Sep-2019 42 54
Anyone have an idea for this?

  0 Comments

Sign in to comment.

Accepted Answer

Sean de Wolski
Sean de Wolski on 13 Sep 2019
Look at synchronize it does exactly this:
tt = timetable(dateshift(datetime,'start','day'), 42, 'VariableNames',"Cars")
tt2 = timetable([dateshift(datetime,'start','day');datetime], [42;17], 'VariableNames',"Buses")
synchronize(tt,tt2,"intersection")
And if you want to play with this kind of thing interactively, in 19b, which shipped yesterday, you can use the join tables "Live Task".
2019-09-13_16-50-26.png

More Answers (0)

Sign in to answer this question.