I'm not sure if there is an easy way to do this without a function (or even then...) but...
I have the following supervisor hierarchy:
Person 1 > Person 2 > Person 3 > Person 1
I can find the looping hierarchies no problem, but I get three records:
1 > 2 > 3
2 > 3 > 1
3 > 2 > 1
Can anyone think of a way to consolidate those three records to only one, since the loop data is the same (it's just the starting point that differs in each record)?
I have the following supervisor hierarchy:
Person 1 > Person 2 > Person 3 > Person 1
I can find the looping hierarchies no problem, but I get three records:
1 > 2 > 3
2 > 3 > 1
3 > 2 > 1
Can anyone think of a way to consolidate those three records to only one, since the loop data is the same (it's just the starting point that differs in each record)?
Comment