4 Replies Latest reply: Jun 7, 2012 11:02 AM by Philippe Franck RSS

    Using Hierarchy with multiple values in tables



      I'm trying to use the Hierarchy key word in a structured multi lingual environment.


      My source table is as below:


      ID     Parent ID     Location_EN     Location_FR

      1                         UK                    Royaume Uni

      2     1                   London               Londres


      The result I would like to get is:

      ID   Parent ID   Location_EN1   Location_EN2  Location_FR1  Location_FR2

      1                     UK                                         Royaume Uni

      2    1               UK                    London           Royaume Uni   Londres


      I tried doing two hierarchy on the same table, but the result is two tables instead of one


      Message was edited by: Philippe Franck