Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is the differences between Hierarchy with function and without function.

Hi All

Can someone please confirm whether hierarchy with function(Method:1) works in the same way as hierarchy without function(Method:2)? If both works in the same way then its fine. If not please let me know what are differences between these two methods?

Method:1

Hierarchy(NodeID, ParentID, NodeName) Load
NodeID,
ParentID,
NodeName
From data.xls (biff, embedded labels, table is
[Sheet1$];

Method:2

Load
NodeID,
ParentID,
NodeName,
NodeID&'/'&ParentID&'/'&NodeName AS Tree
From data.xls (biff, embedded labels, table is
[Sheet1$];

Thanks,
Attitude

1 Reply
jcarpenter9
Partner - Creator
Partner - Creator

Both will probably work if your data includes rows for all of the ParentID values as NodeID. I tried your without-function method on data where NodeID only represented the child values; the list box displayed correctly in tree view, but only the child values were selectable, while the parent values were always greyed out.

Please try both methods with some sample data and post your results here.

~James