MATLAB: Is there a function in matlab that works like vlookup in Excel

time history datavlookup

I have two different time history data sets. Most of the timestamps line up exactly, but some do not (each one has occaisonal dropouts). I want to create a combined set that lines up the two data sets for those times where both data items are available, and then throws out any timestamps where either one is missing data. Thanks

Best Answer

If you're storing your data in timetable arrays, synchronize the timetables and/or remove the missing values using rmmissing. Note that timetable, synchronize, and rmmissing were introduced in release R2016b.
Related Question