I put something together that does both the Path and the Top Parent which looks like this:
Path results:
Top Parent results:
Note: The main purpose of the workflow was for retrieving the Path. But since it already compiled the data, I’m able to retrieve the Top Parent also. But I believe that, for the Top Parent, the solution in the other thread is more optimized - or perhaps the solution by @tobias.koetter could be, but I’m not able to test it as I have the same “problem” as @aworker (Knime 4.4.x vs 4.5.x)
Here’s the workflow: Parent-Child Hierarchy.knwf (30.5 KB)