Comparing dates on two files to return correct hourly rate

[ClaireReece]

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

[binuacs]

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

[ClaireReece]

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

[binuacs]

@ClaireReece Something like below?