MATLAB: Match data by date

Question

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

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