Forum Discussion
Path function parent multiple values
Hello everyone
In the organization I work for, an employee can move from one manager to another manager in some period of time, so I need to find a solution that will allow creating a new hierarchy path based on a date. Is it possible?
here is an example:
| Date | ManagerId | Person Id |
| 01/01/2022 | 1 | |
| 01/01/2022 | 1 | 2 |
| 01/01/2022 | 1 | 3 |
| 01/01/2022 | 2 | 4 |
| 02/01/2022 | 3 | 4 |
for this scenario, I would except to get that path:
| Path | Date | ManagerId | Person Id |
| 1 | 01/01/2022 | 1 | |
| 1|2 | 01/01/2022 | 1 | 2 |
| 1|3 | 01/01/2022 | 1 | 3 |
| 1|2|4 | 01/01/2022 | 2 | 4 |
| 1|3|4 | 02/01/2022 | 3 | 4 |
The path function doesnt let me build a path because some of my values got more than one parent, like person id '4' in this example.
Thank You.
3 Replies
Hey Ofiro1234 ,
you can't create this for a simple reason: it's not possible that a child has multiple parents.
Regards,
Tom
Thank you for your response.
do you know if there is any other solution for this scenario? maybe without the path function.
Hello did you find a solution? I have the same problem. Some employees belong to 2 different departments so they have 2 managers so they have duplicated values in my table.
Thank you
