Hi. I have the following simplified 2 data sources:
| Session | Date | Timing | Title |
| 1 | 3 May | 0800 - 0830 | Title A |
| 2 | 5 May | 0900 - 0930 | Title B |
| 1 | 3 May | 0900 - 0930 | Title C |
| 3 | 4 May | 0800 - 0900 | Titile D |
| 1 | 5 May | 1230 - 1230 | Title E |
| ID | Session | Date | Start Time | End Time |
| 1234 | 1 | 3 May | 0822 | 0845 |
| 4567 | 3 | 4 May | 1010 | 1012 |
| 8910 | 1 | 5 May | 1236 | 1259 |
| 1112 | 1 | 3 May | 0920 | 0930 |
What I wish to do is to find the Title to each ID given the Start Time, End Time, Session and Date. So in this case, for ID 1234, the title would be Title A. The first data table signify the schedule. I wish to find out the Title which ID tune in to based on the schedule.
If the start time and End time falls within the Timing range, and have the same Session and Date, I am to map the Title.
What I did was to split the Timing into 2 columns. But the problem i'm facing is when I attempt to use 'Join' to match the Timing against the Start Time and End Time, it could not have work since they are not identical.
How do i go about doing this? I would greatly appreciate your help.
