Hi Community,
I am working on this use case. Wondering if this is possible.
DAT01 Emp Details
Emp | Start Rate
EmpA 15
EmpB 16
EmpC 17
SYS02 Zone Module
Zone| Lower Range | Upper Range
ZoneA 14 15
Zone B 15 16
Zone C 17 100
How can I identify which Zone does an employee falls in.
Final result needed
Emp | Zone
EmpA Zone A
EmpB Zone B
EmpC Zone C
Any ideas?