Skip to Content
avatar image
Former Member

Hierarchy Import

Hi,

I have hierarchy as per below example :

Parent1

Child 1

Child2

Parent 2(This is nothing but child1 in some case)

Child11

child22

In my excel, I have column :

Parent Child

xxxx 1111-2222

yyyy 2222-3333

I have tried different options like partition , split into hierarchy etc but was not able to import the hierarchy as per above structure. Can someone help me with detailed step by step process?

BR,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 27, 2009 at 02:22 PM

    Hi,

    If i have understood the scenario correctly,

    Parent

    Child 1

    Child 2

    Parent has two children....

    and Child 1 has further 2 children

    Parent

    Child1

    Child11

    Child12

    Child2

    A

    B

    B1

    B2

    C

    i.e. A is the Parent, having two children B and C and B1 and B2 are the children of B.

    To get the above hierarchy.... use the following steps:

    1. Create a file in excel with three colums

    Parent Child Children

    A B B1

    A B B2

    A C

    2. Then Partition the fileds normally Parent -> Child -> Children

    3. When you will map the fields you will get the underlying hierarchy...

    Hope this helps..

    Regards,

    Parul

    Add comment
    10|10000 characters needed characters exceeded