Join leaf nodes with respective parent nodes

Diego_780 — Mon, 20 Dec 2021 08:37:43 GMT

Hello,

So I managed to get two node tables in which in one of them, I have the "tree" or structure of the nodes, and in the other table I have the last nodes of that table (Leaf nodes).

I would like to make a full table where I have in Column 1, the Distinct Leaf node Values and in Column 2, have one-on-one, all the parents that this node can have.

So imagine I have this structure of nodes:

As you can see, the leaf nodes are CM1011, CM1012, CM1021 and CM1022. So I want to have a table which would be something like this:

As you can see, the leaf nodes all are joined with their parent nodes. These are my tables:

Tree nodes (structure):

Leaf nodes:

May you help me with this problem?

Thanks regardless.

topic Join leaf nodes with respective parent nodes in QlikView

Join leaf nodes with respective parent nodes