Match interval in unlinked tables

[#1]

Hello all!

I have a bench of meeting rooms reservation logs on one side (start time, end time).

I would like to know, for each time slot contained in an excel file, how many meeting rooms are booked.

I tried several solutions, but no idea how to go further.

I attached the log file, interval excel and qvw.

Thanks for your ideas.

Hub

[Anonymous]

Have you tried the interval match script command ?

Jonathan

[er_mohit · Accepted solution]

See the attached my application

hope it helps you

[#4]

Thank you both for your comment!

It really helped!

I had to put the time slots in the start_end time of booking interval, which I figured out after spending 2 hours trying to do the things in the opposite way

Once again, great! it works ! Thanks!