Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) LoadID,ParentID,NameResident 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.