0 Replies Latest reply: May 15, 2017 11:00 AM by Olli Holmala RSS

    Beginner Questions About Hierarchy Load

    Olli Holmala

      Hi,

       

      I am attempting to create links between different rows belonging to one single table. I think that the solution to my problem would be a Hierarchy Load, but I can not seem to get it to work.

       

      I am unsure that I understood the requirements correctly though. The way I understand Hierarchy Load is, that it requires an ajacent nodes table. It requires a NodeID and ParentID. In my table, I have the ID field and a ParentID field that is simply the ID of the parent row. This should fulfill the criteria required for Hierarchy Load.

       

      Naturally, in addition to those, I also have plenty of other fields in the table. My first question is, are these extra fields a problem for the Hierarchy Load?

       

      Secondly, I just finished my first successful Hierarchy Load (lasted a mere 25 minutes...) and it's removed the table that it was loaded from altogether! Should I have created a separate "buffer" adjacent nodes table that takes the ID and parentID from my table, and then use that to do the Hierarchy Load?

       

      Any help would be greatly appreciated!

      .