Putting time series data together

I have imported three excel files as tables: calendar, data1, data 2. I have unstacked data 1 and data 2 and now I want to put data 1 and data 2 into the calendar table and use the date column in all three as the joining key. Data 1 and data 2 are over 1000 columns wide and there are time intervals where there is no data in each of data 1 and 2 and these missing data timestamps varry between data 1 and data 2. Essentially I want to use the calender table as a "master" table as it only has dates as a variable and then insert the data from data 1 and data 2. I am trying to time align the data and I have tried inner and outer join and horizonal concat with no success. Any help would be greatly appreciated

[dpb]

I don't know about the table operations as don't have recent-enough version. I'd likely use independent vectors for the time stamps and combination of intersect and friends to select the rows and then insert those results into the table.