5 Replies Latest reply: Apr 27, 2015 5:46 AM by Christian Wylezol RSS

    Hierarchy

    Christian Wylezol

      Hi everybody,

       

      maybe some of you could help me.

      I am trying to make an Hierarchy out of an Excel but I dont get it to work.

      Where is the mistake? I think it has something to do with the different names.

       


      CODE_C:
      Hierarchy(CODE_C_NodeID, CODE_C_ParentID, Code_C_Name, CODE_C_ParentName ,CODE_C_NodeName , CODE_C_PathName, '/' ,CODE_C_Depth)
      //Load *,
      //& CODE_C_Code &'/' &CODE_C_Name &'/' &CODE_C_Acronym as TreeView;
      LOAD CODE_C_NodeID,
      CODE_C_ParentID,
      CODE_C_Code,
      CODE_C_Name,
      CODE_C_Name as CODE_C_NodeName,
      CODE_C_Acronym,
      CODE_C_Depth
      FROM
      [...\Struktur IFS.xlsx]
      (
      ooxml, embedded labels, table is CODE_C);

       


      Thanks in advance.

      Chris