org_chart_doubt

[satishqlik]

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;