How to merge two timetables with different data and time?

12 次查看（过去 30 天）
Wolfgang McCormack
Wolfgang McCormack 2021-1-18
评论： Wolfgang McCormack 2021-3-12
Hi everyone, I had a nice and clean time table that I had to extract some sections of it for calculations during different hours of day. For example Jan to May 10 to 14 and 0 to 10 and 14 to 00. Now I have three time tables from the extracted one. I want to merge them again so that I will have one clean timetable with only one column of data rather than 3 columns with NaN (that what I am getting). Also, [T1;T2] is not working and retrns the following error:
All tables in the bracketed expression must have the same number of rows.
  5 个评论
显示 3更早的评论
Wolfgang McCormack
Wolfgang McCormack 2021-3-10
@Adam Danz Hi, could you please post this to the answer so that I can mark it as the answer?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Adam Danz
Adam Danz 2021-3-10
Ran in:
> [T1;T2] is not working and retrns the following error: All tables in the bracketed expression must have the same number of rows.
This is fishy. The example below shows that a vertical concatenation is perfectly fine when the tables have a different number of rows.
Please share
  1. the result of head(T) for each table
  2. the line of code where you're doing the concatenation
  3. the entire error message.
Demo:
T1 = array2timetable((1:3)'.*ones(1,4), 'RowTimes', datetime('today')+(0:2))
T1 = 3x4 timetable
Time Var1 Var2 Var3 Var4 ___________ ____ ____ ____ ____ 10-Mar-2021 1 1 1 1 11-Mar-2021 2 2 2 2 12-Mar-2021 3 3 3 3
T2 = array2timetable((1:5)'.*ones(1,4), 'RowTimes', datetime('today')+(0:4))
T2 = 5x4 timetable
Time Var1 Var2 Var3 Var4 ___________ ____ ____ ____ ____ 10-Mar-2021 1 1 1 1 11-Mar-2021 2 2 2 2 12-Mar-2021 3 3 3 3 13-Mar-2021 4 4 4 4 14-Mar-2021 5 5 5 5
T = [T1; T2]
T = 8x4 timetable
Time Var1 Var2 Var3 Var4 ___________ ____ ____ ____ ____ 10-Mar-2021 1 1 1 1 11-Mar-2021 2 2 2 2 12-Mar-2021 3 3 3 3 10-Mar-2021 1 1 1 1 11-Mar-2021 2 2 2 2 12-Mar-2021 3 3 3 3 13-Mar-2021 4 4 4 4 14-Mar-2021 5 5 5 5

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by