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?