Comparing dates on two files to return correct hourly rate

Question

Hello, thanks in advance for reading

I have a file that details hours worked on a specific date and another file that details employee rate history. I would like Alteryx to look at the date that the hours were worked and return the correct rate from the employee history. I am very new to all of the tools so would appreciate any guidance.

Many thanks

Employee Data.xlsx

Hours Worked.xlsx

binu_acs · Answer

@ClaireReece Something like below?

Hourly_Rate_031023.yxmd

ClaireReece · Answer

Hello

As the hours in this example have been worked after the 2nd pay change I would like it to return the second hourly rate of 15

binu_acs · Answer

@ClaireReece What is the expected result? How you relate the Hours worked with the Employee Data?