Generate "child" column in data model

[CasperQlik]

Hi QlikCommunity

I need help expanding my data model.

I have a data structure like this:

noteID	parentID
1
2	1
2	7
2	4
3	2
3	8
4	1

I consists of nodes and "parent" nodes. It is a fairly simple structure that depicts the relationship between nodes. Nodes can have either no, one or multiple parents.

I need a new field that contains the Id of any child nodes. Essentially as this table here:

noteID	parentID	chidID
1		2
1		4
2	1	3
2	7	3
2	4	3
3	2
3	8
4	1	2

This way it is visible which "parents" a node has and a nodes "children". 

Any help is appreciated

//Casper

[steeefan · Accepted solution]

Have you tried using Hierarchy or HierarchyBelongsTo?

[CasperQlik]

I found a solution with a mix of the two. Thank you.

[Ahidhar]

Could you share the solution