2 Replies Latest reply: Sep 16, 2015 5:35 AM by Subramanya Vanka RSS

    Removing Redundancies in Hierarchies

      hier.JPG

      Hello Guys,

       

      The above table is a Hierarchy table with Redundancies.

       

      i.e. World->Americas->CA is redundant as World->Americas->CA->NAPA better describes the hierarchy.


      Another redundancy: World-> Europe ->Germany is Redundant as World-> Europe ->Germany-> Rheingau

       

      I want to remove all redundancies like this from the entire table.

       

       

      My question is how do I remove these from the script? Do I use a where clause to weed out these redundancies?