Hierarchy loading in Import Manager

Hi,

I have the following scenario to load Hierarchy but Import Manager is throwing an error message ' Duplicate in Clomn-2".

However the same structure I am able to make in Data Manger manually for a 3 level hierarchy which confirm that hierarchy table supports that structure.

Column1 Column-2

(parent) (Child)

-

-

3M

3M Abrasive

Abrasive Roll

3M Coil

Coil Copper

GE Abrasive

SH-Ent Coil

The data shows Manufacturer 3M and GE both have 'Abrasive' which is very normal but not able to load thru 'create Hierarchy' option after selecting 2 flds in IM.

IM throws a duplicate error , "Duplicate in Column-2: Abrasive"

Hope the example communicates properly.

Appreciate ur help/tips

-reo