Hi all,
I'm trying to do something that I think SHOULD work but I can't get it quite straight in my head so I'd appreciate some support.
I've got a module that's holding employee data, dimensioned by Employee ID and by month. I need to be able to identify people managers, but the data extract doesn't have a flag for that. What I DO have is a line item that indicates each employee's line manager's employee ID like this (all employee numbers are randomised here):
P_PERIOD_NAME | EMPLOYEE_NUMBER | MANAGER_NUMBER |
Apr-20 | 18631 | 34666 |
Apr-20 | 46611 | 7845 |
Apr-20 | 25541 | 13009 |
Apr-20 | 49355 | 47465 |
Apr-20 | 29222 | 21253 |
Apr-20 | 5960 | 43499 |
What I'm trying to do, I guess, is the equivalent of an excel vlookup to find an item in Manager_number that matches the Employee_Number so I can have a boolean that shows as true if the employee's ID is in the manager number line item anywhere, but so far none of the lookups I've attempted have worked as I want them to.
Can anyone give me a steer in the right direction?