Path function parent multiple values

[Ofiro1234]

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.

[TomMartens]

Hey @Ofiro1234 ,

you can't create this for a simple reason: it's not possible that a child has multiple parents.

Regards,

Tom

[Ofiro1234]

Thank you for your response.

do you know if there is any other solution for this scenario? maybe without the path function.

[DM_W]

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