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

    Using Hierarchy with multiple values in tables

      Hi

       

      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