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.