none
Multiple hierarchy levels from single table

    Question

  • Happy 2014 for everyone!

    Here is my first problem of the year: I got a product table with "coded" hierarchy, like this:

    1  Level
    11  Level
    111  Level
    1111  Level
    11111  Product
    11112  Product
    11113  Product
    1112  Level
    11121  Product
    112  Level
    1121  Level
    11211  Level
    112111  Product
    112112  Product
    112113  Product

     

    How should I go about to create an hierarchy from this table? Keeping in mind that products could be in different levels.

    Any ideas please?

    Thanks very much!

    Tuesday, January 07, 2014 5:48 PM

Answers

All replies