Help Linking tables (using Interval Match)

[Anonymous]

I have 2 tables which I need to link but I am having problems with.

I have a list of shifts, by person, by date.  I also have a table to show which dept they were in on a given date.

Is there a way I can create an output based on how the tables are configures.

Please see my excel example

Thanks in advance

Phil

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[Anonymous]

Fantastic

Thanks for the quick response

Phil