Hello I was wondering if you could give me a gentle hand in here.
I have the table sorted in this way , there is a hierarchy, certain activity and a suppliers in charge. Every supplier must on top approve the activities for the suppleirs below his node. And I would like to get this approval loop from each of the suppliers lines. This will be the initial dataset:
In the end I am interested to get in a consolidated column all approvers sorted according to the hierarchy nodes. Something like this:
I am wondering which will be the most efficient way. The real data have plenty of rows but this is a zoom into the data set samples.
Thanks for helping me out.
I have the table sorted in this way , there is a hierarchy, certain activity and a suppliers in charge. Every supplier must on top approve the activities for the suppleirs below his node. And I would like to get this approval loop from each of the suppliers lines. This will be the initial dataset:
hierarchy level | contract | Supplier |
0 | A | TEST0 |
1.00 | B | TEST |
1.00.01 | C | TEST2 |
1.00.01..01 | D | TEST3 |
2.00 | E | TEST4 |
2.00.01 | F | TEST5 |
In the end I am interested to get in a consolidated column all approvers sorted according to the hierarchy nodes. Something like this:
hierarchy level | contract | Supplier | Approver |
0.00 | A | TEST0 | ROOT |
1.00 | B | TEST1 | TEST0 |
1.00.01 | C | TEST2 | TEST1:TEST0 |
1.00.01..01 | D | TEST3 | TEST2:TEST1:TEST0 |
2.00 | E | TEST4 | TEST0 |
2.00.01 | F | TEST5 | TEST4:TEST0 |
I am wondering which will be the most efficient way. The real data have plenty of rows but this is a zoom into the data set samples.
Thanks for helping me out.