Merge two data sets based on time window

[shansakhi]

Hello All,
I have two data sets - Data Set 1 and Data Set 2.
I want to take Bus No from Data set 1 and incorporate in Data Set 2 using below criteria.

1. Dep Date
2. Dept Sta
3. Arvl Sta
4. Need to see if Dept Time in Data Set 1 is coming between DepartureTimeWindow in Data Set 2.

Attached is the Screenshot with Data Set 1, Data Set 2 and Output.

Regards,
Shan

 

[shansakhi]

Sorry for late reply.
Thank you So much. It is working as desired.