Add timetable with many months to another timetable with few months

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?

Answer 1

[Sean de Wolski]

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".

[Adam Danz]

+1

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

[Martin]

thanks a lot