Importing a hierarchy field

[Former Member]

Hi,

Is it possible to import a field that contains hierarchies with no delimiter to a hierarchy table? For example - the field "1015" the first 2 figures (10) represent a father in the hierarchy and the last 2 figures (15) are the child?

Is it possible to split and import as hierarchy even though there is no delimiter between the 10 and the 15?

Thanks,

Tal

[Former Member · Accepted solution]

Hi,

it is not possible to split into hierarachy when there is delimeter between two fields.

Ex: 1015.

hope this may help you,

regards,

srinivas

[Former Member]

Hi Tal,

Hierarchies can be imported easily if you have a source file clearly indicating hierarchy levels.

For your case , you can use excel formulas(LEFT & RIGHT) to prepare a file with three columns as follows:

(Column1) ( Parent) (Children)

(1015) (=LEFT(2)) (=RIGHT(2))

Which will give you result as:

(Column1) (Parent) (Children)

(1015) (10) (15)

Like this you will now have a file clearly indicating hierarchy levels.

You are now ready to import this file using Import Manager. Use partition tab to prepare hierarchy as you want.

Edited by: AMOL PATKI on Dec 25, 2007 6:38 PM

Edited by: AMOL PATKI on Dec 25, 2007 6:40 PM

[Former Member]

That's what I thought, Thanks.