I have been racking my brain and gotten stuck.
I have a list of ids. Each id has the manager that incumbent report to.
The list is from CEO down to bottom of org including every employee. (~46k rows)
The list is in no particular order.
What I would like to do is analyses on what level each row/incumbent is from the CEO, CEO = 1, anyone have any ideas how to do this rationally and effectively?
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I have a list of ids. Each id has the manager that incumbent report to.
The list is from CEO down to bottom of org including every employee. (~46k rows)
The list is in no particular order.
What I would like to do is analyses on what level each row/incumbent is from the CEO, CEO = 1, anyone have any ideas how to do this rationally and effectively?
emp id | mngr id | emp org level |
2264 | 119 | |
3789 | 119 | |
5881 | 119 | |
100219 | 119 | |
100677 | 119 | |
7551 | 126 | |
11527 | 126 | |
100699 | 137 | |
111394 | 137 | |
26545 | 137 | |
26547 | 137 | |
26552 | 137 | |
26773 | 137 | |
174 | 144 | |
18061 | 144 | |
18062 | 144 | |
27645 | 144 | |
30912 | 144 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>