Skip to Content
0
Former Member
Dec 21, 2007 at 08:16 AM

Hierarchy Import

66 Views

Hi,

I need to import an hierarchy which is in following format in the excel file:

......l1.......................l2............l3................code

Accessories..............................................100

Accessories..............Pen.......................... 101

Accessories..............Pen.......... Blue..........102

Accessories..............Pen.......... Black........103

Accessories..............Pencil.......................104

Accessories..............Marker......................105

Accessories..............Marker......Blue......... 106

Accessories..............Marker......Black........107

When I try partioning l1 by l2 and l3, and map code to the destination code field, I face a problem.

Consider 1st row:

Since l2 and l3 are blank, when l1 is partioned, the tree gets created in following way:

Accessories

|...NULL

|...NULL -- 100

and the code gets mapped to the last NULL.

Similarly NULL are created for row 2,5,6. ie wherever the data is not filled in all columns.

What should be the correct way of partioning/importing hierarchy data which is in above format?

Thanks,

Ketan

Edited by: Ketan Phanse on Dec 21, 2007 1:46 PM