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

ipazin December 6, 2021, 11:38am 4

Hello @dimi,

this topic provides discussion on this topic:

Br,
Ivan

1 Like