This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would say that in most companies, you would probably have less than 15 levels to the hierachy and so you could just concatenate join tools to get this result with a transpose at the end.
The way this would work, is to run your input referential table into both sides of a Join tool, joining Employee ID to ManagerID, rename the new Employee ID to Level3 or similar, then Union the L&J outputs to make a Left Outer Join, Join this to the original Data on Level3 = ManagerID, rename, Union and repeat. You will end up with a table with Manager ID and then several columns for each of the levels under that, so transpose all the other fields, Filter Null() out, Sort and Unique. This doesn't have each employee linked to itself, and so you can add in EmployeeID joined to Employee ID as well, renamed and Unioned.
Sample Attached. You could turn this into a iterative macro, however you would need to play around with it, and you could proably knock this method out in 15 minutes or so.
I'm attaching a dummy case for your study. In this case, besides the use of an iterative macro, you'll see Append Fields dong big part of the job, which for what I understood, is the kind of approach you're looking for.
Append Fields, will append (duh!) the records from a source (S) to every record on the target (T).
If you bare the behaviour of the iterative macro, you'll find out that this Target input is your Universe.
Is a basic "all combinations set", but you'll find it useful as starting point for what you want to accomplish.
PS: Thanks CailinS for the original idea/case/exercise.
I am looking for a workflow which helps me a create a employee-> manager 1 -> Manager 2 -> Manager 3 .....in seperate columns..What I have is Employee ID'S in one column and the corresponding manager ID'S in the next column..