Hierarchy Tree view was empty

[mustafaelryah]

dHello all,

I,m testing the tree view hierarchy with Family tree, I had excel sheet,

my columns is

	name,
	number,
	level,
	[Father number],
	Gender

I made join function to get the father name  and it worked

then I create hierarchy function but shown empy

kindly find below here the code:

Person:

Hierarchy(number, [Father number], name,,Father_Name, TreeView) Load

     name,

     number,

     level,

     [Father number],

     Gender

FROM

(ooxml, embedded labels, table is Sheet1);

inner Join (Person)

LOAD name as Father_Name,

number as [Father number]

Resident Person;

--------------

kindly check the below view of the empty tree:

kindly find the data details view:

Waiting for your ideas to solve the empty TreeView

[Gysbert_Wassenaar · Accepted solution]

Try this:

Person:

Hierarchy(number, [Father number], name,Father_Name,name, TreeView) Load

     name,

     number,

     level,

     [Father number],

     Gender

FROM

(ooxml, embedded labels, table is Sheet1);

[mustafaelryah]

worked successfully , kindly can you explain what happened ?

[Anil_Babu_Samineni]

Delete one Comma from there

Hierarchy(number, [Father number], name,Father_Name, TreeView) Load

Person:

Hierarchy(number, [Father number], name,Father_Name, TreeView) Load

     name,

     number,

     level,

     [Father number],

     Gender

FROM

(ooxml, embedded labels, table is Sheet1);

inner Join (Person)

LOAD name as Father_Name,

number as [Father number]

Resident Person;