hierarcy

[#1]

Hi,

I am trying to build the hierarchy using the recursive way since the data is not organzied. I tried concatenating and use it is working. But i am not sure how to use the hierarchy and hierarchy belongs on thge below data.

Parent	Child	Name
1	11	a
2	12	b
3	13	c
4	14	d
5	15	e
6	16	f
7	17	g
8	18	h
9	19	i
10	20	j

.

Another seperate parenchild table, 

Parent	Name1	Name
p	aa	a
c	bb	b
p	cc	c
c	dd	d
p	ee	e
c	ff	f
p	gg	g
c	hh	h
p	ii	i
c	jj	j

[#2]

Hi,

i hope this help you.

C u,

Stefano.

[#3]

Thanks for your response.

Can u please provide me a sample qvw for the given data.

[#4]

Hi,

but thoose table not seem to be Adjacent Nodes table.

Is it your real situation or your example?

hierarchy and hierarchybelongsto want Adjacent Nodes Table in input.

Each node in the 1st table has different parent and in the 2nd the root is not present.

C u,

Stefano.

[SunilChauhan]

rename parent in sect table

left join first with second on basis of Name

then apply hierarchy

Paren&'/'&Child&'/'&Name ... as hierarchy

take hierachy in list box and in general check on tree view and provide seperator