Hi Everyone,
please help me on below hierarchies script and suggest where i did wrong.
I have a table it has two fields emp ID and reporting Manager ID
now am going to create hierarchy
temp:
LOAD Text([Emp No.]) as ID1,
Text([Reporting Manager Emp ID]) as RM
FROM
<>;
TreeView:
LOAD Distinct
ID1 as Value,
ID1&'-ID1' as Node_ID,
RM&'-RM' as Parent_Node_ID
Resident temp;
LOAD Distinct
RM as Value,
RM&'-RM' as Node_ID,
RM&'-RM' as Parent_Node_ID
Resident temp;
HirTable:
Hierarchy(Node_ID_H,Parent_Node_ID_H,ID,Parent_Name,Name,ORG)
LOAD
Value as ID,
Value as Name,
Node_ID,
Node_ID as Node_ID_H,
Parent_Node_ID as Parent_Node_ID_H
Resident TreeView;