Combine Data based on Dates

[Glynn1969]

Hello, apologies as i'm new to Qlik Sense so this may be a simple solution but you only know what you know and everything else is learning!!

I am looking to load 2 QVD data sets and to combine them based on a date, I have two Data Sets as follows:-

First Data Set: - shows name and a date of sale they made

Second Data Set: - show name and their office location and the period of time in that location.

My required output is to show the name of the person, the date of sale and to pull in the persons office location at the time of the sale, wanting to do this through the data load if possible (see example below)

[Kushal_Chawda]

@Glynn1969  you need IntervalMatch

[Gabbar]

There are two ways to do it first is interval match and second is
you could join both table on SalesPerson 
and the use the output table as resident table and use where Dateofsale between office start and office end