Problem with Hierarchy

[tizianacaem]

hi all,
I have a problem with the linearization of the bills of material.
I have a table which has on the same line the parent code and child code, with the use's factor for son.

The sono code can become a father in another row, with the relative use's factor.
eg.

FATHER	SON	FACTOR-USE
A	B	2
A	C	3
B	D	1
C	E	2
C	F	2
D	F	1
G	H	1
H	E	2

I want the linearization of the bill, so that I can bind the parent code and how many children are need to make the father.

eg. father A needs 2B, 3C, 2D, 6E, 8F  Father G needs 1H, 2E etc.

I did experiment with the function Hierarchy, but I can't able to define the use's factor.

Any ideas please?

thanks

Tiziana

[adnan_rafiq]

I am not really sure about your exact requirment

but i guess here is the logic that might be helpful

load Hiearchy repeatedly see below script to get an idea.

It will create link with one hierarchy table to other you will see like

A is linked to C and B and also E , F through C and B and so on

Hierarchy (SON, FATHER,A)

LOAD FATHER,

     SON,

    'Dum' as A

FROM

[Hiearchy test.xlsx]

(ooxml, embedded labels, table is Sheet1);

Hierarchy ( SON_1,SON, B)

LOAD FATHER as SON,

     SON as SON_1 ,

'Dum' as B

FROM

[Hiearchy test.xlsx]

(ooxml, embedded labels, table is Sheet1);

Hierarchy ( SON_2,SON_1, C)

LOAD FATHER as SON_1,

     SON as SON_2 ,

'Dum' as C

FROM

[Hiearchy test.xlsx]

(ooxml, embedded labels, table is Sheet1);

Regards