Hi,
Here is my script to create hierarchical data
Employees:
LOAD [Emp No.] as EmpID,
[Emp No.] as EmployeeName,
[Reporting Manager Emp ID] as [Reports To]
FROM
(biff, embedded labels, table is Sheet1$);
Hierarchy:
Hierarchy (EmpID, ManagerID, EmpName, Manager, EmpName, EmpHierarchy, '/', Depth)
LOAD EmpID,
EmployeeName as EmpName,
[Reports To] as ManagerID
Resident Employees;
Now am using D3 Tree Layout extention to create Org chart
In the list box, if I select EmpID then it is not showing corresponding hierarical data.
PFA for your reference.
I have tried with below script
Hierarchybelongsto:
HierarchyBelongsTo(EmpID, ManagerID, EmpName, ManagerID, AncestorName, DepthDiff)
LOAD EmpID,
EmployeeName as EmpName,
[Reports To] as ManagerID
Resident Employees;
Any ideas will be appreciated.
