how to merge multiple timetable
6 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Sehoon Chang
am 21 Aug. 2020
Kommentiert: Cris LaPierre
am 23 Aug. 2020
dear advisers,
i have multiple timetables with different timestamps (yyyy-mm-dd hh:mm), but within a same time period.
I wish to merge multiple timetables into a single timetable, and the measurement recorded for each corresponding timestamps shall be organized in ascending order (e.g. 2020-08-01 0:00 , 2008-08-01 1:00, ....).
Thank you for your advice.
0 Kommentare
Akzeptierte Antwort
Cris LaPierre
am 23 Aug. 2020
You might be able to use synchronize. If you have more than 2 tables, you will need to use it multiple times.
2 Kommentare
J. Alex Lee
am 23 Aug. 2020
Just a quick note this would probably require conversion of your tables into timetables first with table2timetable().
Also based on quick read of the docs, doesn't appear to have an option to behave more like a join, i.e., do not fill missing? Anyway I suppose it ultimately depends on exactly what the end objective is.
Weitere Antworten (1)
J. Alex Lee
am 21 Aug. 2020
Bearbeitet: J. Alex Lee
am 21 Aug. 2020
If the tables have the same columns, you should be able to simply vertically concatenate them and sort
t0 = sortrows(vertcat(t1,t2,t3))
4 Kommentare
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!