Could you please look at it for a while as I am stuck with no ideas.
I have one column (accountnum) with following rows:
1
12
1234
2
21
213
3
311
31122
I need tu build a hierarchy so levels where associated sth like this:
Level1 Level2 Level3 Level4
1 12 1234 12345
2 21 213 -
3 311 31122 -
Numbers of nodes are not regular if there is not parent for Accountname (Parent =left( AccountName -, len(AccountName)-1) it should look for len(AccountName)-2 ) ect.
I should probably use Hierarchy Load here but how to find a parent???
