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