How to merge two timetables with different data and time?

29 views (last 30 days)
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 Comments

Sign in to comment.

Accepted Answer

Adam Danz
Adam Danz on 10 Mar 2021
> [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

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!