MATLAB: Combine Tables with different record rate

Question

Hey Everybody,

I need to join two tables by the common Parameter "Time_secs_" which represents the record date of my sensor data. Unfortunately, in one table the record is 0.5 seconds while in the second it is 0.1 seconds. Therefore the second table has 481002 rows while the first only has 80167 rows.

Now I want to join them by their record rate and simply add blank cells for every signal from table 1 to the time_secs_0 0.1, 0.2, 0.25, 0.3, 0.4, 0.6, 0.7, 0.75, 0.8, 0.9 (some signals are also taken every 0.25 seconds, thats why 0.25 and 0.75 are included).

How can I do this? Is there any specification I can make to the "join"-function or will it not work with this at all?

Thanks a lot in advance!

Answer 1

How can I create an additional column within the table which contains all the information of those three others and makes a time out of this?

yourtable.newcolumnname = datetime([zeros(height(yourtable), 3), yourtable.hourcolumn, yourtable.minutecolumn, yourtable.secondcolumn], 'Format', 'HH:mm:ss')