How to simultaneously use logical indexing and date time indexing in a timetable?

Hi,

Let's say I have a timetable with one of the variables being logical indexes, and I want to extract data from this timetable using that logical indexing from the timetable and a certain timerange at the same time. Doing something like this:

extracted_data = TT(trange & TT.Var_log_idx==true,'Var3');

I would like to be able to do this all in one statement. Hope that explains it, I have attached a mat file with a sample timetable and a timerange if you wish to try.

Any help is appreciated,

Thanks!

Answer 1

[HWIK]

Not to delete this question, I will answer it with what I found to be the closest to what I wanted through some documentation.

There are a bunch of functions which can do this: withinrange, containsrange and overlapsrange. Where, you can get the logical indexing using the second output of these functions:

[tf, idx] = withinrange(TT,trange);

[Peter Perkins]

Another possibility would be to and together the result of isbetween and the logical variable. timerange is essentially a wrapper around isbetween, which itself is just a wrapper around < and >.