Creating Hierarchy

[Former Member]

Hi All

I am trying to import data into a Hierarchy table . The data looks like this

Code Desc

500000 Common

500010 Coatings

500020 Enamels

500040 Chemicals

500050 Application Tap

500060 Plastic GIG

500070 Glass Deco

500080 GLOB

and I want the hierachy to be created with code

Common

Coatings

Enamels

Chemicals

Appl....

But when I select the Code and Desc and from the context menu try to click on "Create Hierarchy Field" , i find the selection disabled. Where am I going wrong. What is that I should do to create the hierarchy along with the code.

Regards

Ray

[Former Member]

Hi Ray,

The data source must be updateable in order for MDM to perform the Create Hierarchy Field command and create the delimited hierarchy field. The command adds the split hierarchy field to the underlying data source if it is updateable.

So, if your source is excel file,

1. convert it into tab delimited text file.

2. Open Import Manager, choose the file type 'Delimited text' and delimiter '\t'.

3.Choose the Source Hierarchy and the Destination Hierarchy. Select both code and desc and then right click on them. Create Hierarchy field will be active.

Hope it will help you.

Regards

Richa

[Former Member]

Hi,

Creating Hierarchy Field needs an Updatable database like Access,Delimited Text etc.Create one tab delimited text file that contains the hierarchy shown and try importing that it will surely work.

Please reward.

Regards,

Jitesh Talreja