Add timetable with many months to another timetable with few months

1 view (last 30 days)
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?

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)

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!