Help required for Hierarchy!

[#1]

Hi All,

When I use the below script though the hierarchy that has been formed is correct. When I click on any data other data other than content it is not getting selected. I found this code is simple to create the hierarchy rather than using this one which i am not able to understand anything.

// Found this one complicated which is there in the help file
<title>Hierarchy</title><link/>
Hierarchy(NodeID, ParentID, NodeName) Load
NodeID,
ParentID,
NodeName,
Attribute
From data.xls (biff, embedded labels, table is [Sheet1$];

//Simple code but not functioning well
new:
Load mfacname as mfac,itemcode,
 mfacname &'|'& itemname &'|'& contentname as Hierarchy,
 itemname as item,
 contentname as content
 RESIDENT items;

Hope some one can help me out.

Thanks and Regards,

Rikab

[#2]

Hi All,

Any one is having solution for this?

Thanks and Regards,

Rikab

[#3]

Hi Dilip,

I hope the attached application will help you.

Regards

Rajesh

[#4]

Hello Rajesh,

Though it works I am not sure how it works. Will be thankful to you if you can explain me how it works.

[#5]

Hello Rajesh,

can you post the excel-sheet from your example, as i try to build a hierarchy on the basis it.

Thank you,

Michael