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

    Removing Redundancies in Hierarchies


      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?