Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hierachy Question

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. error loading image

0 Replies