I’m looking for a efficient solution to build a managerial hierarchy from a “flat” structure. See attachment for input structure and wanted output structure. I managed to do it with several joins and column operators but I ended up having to do the final touches in excel.
Is there a better more sustainable way?
See this wf hierarchy.knwf (59.3 KB).
With the Reference Row splitter and Joiner nodes you can create a chain to step upwards in the hierarchy, so starting with employees without a manager, until you reach the top (the employee with no manager linked).
In the end no Excel needed
I will give it a try on my data set and let you know.
It didn’t fully give me the result I wanted as my data set seems to be more “complex”. Sometimes it will end on N3 and sometimes on N6 etc.
I found this thread however, Parent-Child Hierarchy, that works. I just need to figure out how to reverse the logic so I get top manager to the far left and then descending order. To do that I need to understand what is happening in that flow and that will not be easy
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.