Determining A Line Item By Reference to Other Line Items

Options
phillip.catterall
phillip.catterall Member, ALL USERS, Community Member Posts: 4 Occasional Contributor
in Planning & Modeling

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_NAMEEMPLOYEE_NUMBERMANAGER_NUMBER
Apr-201863134666
Apr-20466117845
Apr-202554113009
Apr-204935547465
Apr-202922221253
Apr-20596043499

 

 

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?

Tagged:

Comments

  • phillip.catterall
    phillip.catterall Member, ALL USERS, Community Member Posts: 4 Occasional Contributor

    Perfect, thank you! Did exactly what I needed.

  • phillip.catterall
    phillip.catterall Member, ALL USERS, Community Member Posts: 4 Occasional Contributor

    Thanks! I ended up going with the other solution just because people can change their management status from month to month and I need each month's data to reflect that; if I'd gone with a manager list all the months would be reflective of whatever was in that list rather than each month being calculated seperately.

Categories