Skip to Content
Former Member
Oct 29, 2009 at 11:33 AM

Uploading to a hierarchy lookup table



I am trying to populate a hierarchy lookup table using import manager, MDM version is 7.1.

My hierarchy has up to three levels, some leaf nodes are at level 2 and some at level 3.

My spreadsheet has rows representing every internal node and every leaf node in the hierearchy. There is a column for each level in the hierarchy. Thus there are some blank fields which are interpreted as nulls I believe.

In import manager, I have used partitioning to create my source hierarchy.

I think I should use the hierarchy null handling option "ignore all trailing nulls" but when I select this the add option "add branch as child" becomes greyed out so I cannot copy the hierarchy to the destination table.

Is there any way round this? Maybe this is a bug?