Multiple child Parent relation hierarchy.

[gshalini]

Hi, I wanted to create a Hierarchy, which can contain multiple parent and child.

Input Data :-

Role	1	2	3	4	5	6	7	8	9
A	R	R	R	R
B	R	R	R	R	R				R
C		R	R	R	R	R	R		R
D				R	R	R	R
E	R	R	R	R	R	R			R
F	R	R	R	R		R

<tbody>
</tbody>

Role A - 1,2,3,4
So each Role is formed with the data's in 1, 2, 3...

Wanted to create a Hierarchy of Parent child relation.

Output expected :-

Parent	A	D
Child	B F	C
Granchild	E

<tbody>
</tbody>

Kindly help me to create Output table for a large data.

<colgroup><col span="7"><col><col span="2"></colgroup><tbody>
</tbody>

 

[Eric W]

Welcome to the Board!

I'm confused. How do you know that B and F are children of A?

 

[gshalini]

Hi Eric,

B and F inherits 1,2,3 and 4 from A. B having an additional of 5 and F with an additional access of 6.

 

[Eric W]

OK, consider this sheet:

	A	B	C	D	E	F	G	H	I	J
1	Role	1	2	3	4	5	6	7	8	9
2	A	R	R
3	B	R	R		R	R
4	C
5	D
6	E	R	R		R	R	R
7	F	R	R				R	R

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet5​

B and F are both children of A, since A has 1/2, and B and F both have 1/2. E is a child of B, but not F. D is a child of F, but not B. How do you want this displayed?

	A	B	C
11	Parent	A	A
12	Child	B	F
13	Grandchild	E	D

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet5​

How deep do you want it? Grandchild, greatgrandchild, great-great-, etc.? How big is your actual table?

And you can also consider E and D to be children of A by your logic. This can get complicated very fast.

 

[gshalini]

Hi Eric,

Apologies for late reply.

Yep the hierarchy which I'm look for will be Grandchild, greatgrandchild, great-great... etc. It may got till 6 levels of relationships.

Basic parent with 1 child will be easy, however requirement is that 1 child may have multiple parent

Regards,
Shalini