Forum Discussion
Solved
Creating a Parent ID Key from a flattened table
I have a table as shown below which shows a organisation hierarchy. I'm trying to create a organisation chart but can't do that with the way my data stands at the moment. After some research I found ...
All you need is an employee table that lists the manager for each employee.
Hi Ashish,
Essentially, I want something that looks like the table below. With the current format I'm struggling to use any of the heirarchy visuals to correctly create my org chart.
| EmpID | EmpName | ManagerID | Path |
| 1 | CEO | 1 | 1 |
| 2 | Paulina | 2 | 1|2 |
| 3 | Patrick | 2 | 1|3 |
| 4 | Paul | 2 | 1|4 |
| 5 | Oscar | 3 | 1|2|5 |
| 6 | Ollie | 3 | 1|3|6 |
| 7 | Odi | 3 | 1|4|7 |
| 8 | Neve | 4 | 1|2|5|8 |
| 9 | Niall | 4 | 1|3|6|9 |
| 10 | Nelly | 4 | 1|4|7|10 |
| 11 | Mindy | 5 | 1|2|5|8|11 |
| 12 | Maggie | 5 | 1|3|6|9|12 |
| 13 | Max | 5 | 1|4|7|10|13 |
| 14 | Lionel | 6 | 1|2|5|8|11|14 |
| 15 | Linda | 6 | 1|3|6|9|12|15 |
| 16 | Lottie | 6 | 1|4|7|10|13|16 |
| 17 | Kevin | 7 | 1|2|5|8|11|14|17 |
| 18 | Kenny | 7 | 1|3|6|9|12|15|18 |
| 19 | Kim | 7 | 1|4|7|10|13|16|19 |
| 20 | John | 8 | 1|2|5|8|11|14|17|20 |
| 21 | Jenny | 8 | 1|3|6|9|12|15|18|21 |
| 22 | James | 8 | 1|4|7|10|13|16|19|22 |
All you need is an employee table that lists the manager for each employee.