1 Reply Latest reply: Aug 7, 2012 9:24 AM by James Carpenter RSS

    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