Dear Knime community! I would like to know whether a node exist that can create the column “path” with the columns “Child ID” and “Parent ID” as inputs: [image] This is a standard function in DAX (PowerBI /SAAS language), which is very useful for Business Intelligence applications. Thank you very much for any tips! Dimitri

I put something together that does both the Path and the Top Parent which looks like this: [image] Path results: [image] Top Parent results: [image] 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)

Parent-Child Hierarchy

KNIME Analytics Platform

tobias.koetter December 7, 2021, 9:06am 9

Hello @dimi ,
please have a look at this example that uses the KNIME Network Mining extension that Ivan mentioned:

Bye
Tobias

6 Likes

Building a hierarchy table from transactions