MATLAB Answers

Martin
1

Add timetable with many months to another timetable with few months

Asked by Martin
on 13 Sep 2019
Latest activity Commented on by 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.

1 Answer

Answer by Sean de Wolski
on 13 Sep 2019
 Accepted Answer

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

  2 Comments

+1
I keep forgetting about synchronize! I guess I need a project that uses timetables.

Sign in to comment.