Hierachy Question

Thu, 10 Feb 2011 17:33:51 GMT

I have used the following code in my script:

T2:
LOAD * INLINE [
ID, ParentID, Name
1, , World
2, 1, Europe
3, 2, UK
4, 2, France
5, 2, Italy
6, 1, Africa
7, 6, Nigeria
8, 6, South Africa
];

Hierarchy(ID, ParentID, Name,,Name,TreeView2) Load
ID,
ParentID,
Name
Resident T2;

drop table T2;

When I view the results of the table T2_Extended I am getting duplicate rows, see attached file.

I know there is something strainge going on but I can't figure it out, please help.

topic Hierachy Question in QlikView