Match data by date

Hi,

I have two 15 years datasets. the first one looks like this: [Date time Xvalue]

the second one looks like this: [Date time Yvalue]

I want to create a new matrix out of the two like this: [Date time Y X]

the problem is that one of them is hourly data and the other one is every 15 min, and the other thing is that they have gaps, so for some hours there is missing Y value or missing X value I want them to be in hourly periods

Any help please?

Answer 1

[Sean de Wolski]

This is the exact purpose to timetable in R2016b. You'll build two timetables, and synchronize them.

[Karoline Qasem]

I will try it. thanks

[Karoline Qasem]

I am in academic matlab license, it said undefined function timetable? and it is 2016a

[Sean de Wolski]

Talk to your IT department or MATLAB administrator about upgrading to the most recent release.