Hierarchy VACANT Positioning in Tree

[aveeeeeee7en]

Hi Community

Need to set the Employees in Tree Structure  who have VACANT Manager Name based on the MANAGER_POS

Regards

Aviral

[SergeyMak]

Hi Nag,

I think you need to add a raw with VACANT employee

Concatenate (Emp)

LOAD * INLINE [

EmpID, Reporting To, Name, DivisionalHead,Department

VACANT, Sanjeev Sinha,VACANT,Sanjeev Sinha,14 Development Dept.

];

and you don't need if([Reporting To]='VACANT',DivisionalHead, [Reporting To]) as [Reporting To New];

PFA

[aveeeeeee7en]

Hi Sergey

Thanks for the Reply but I don't want to do this with Inline function since everytime I don't know who has left the Company.

I don't want this to be done by doing Hard Coding.

Any Other Options???

[SergeyMak · Accepted solution]

Ok. No problem. No hard coding

But the same idea

Concatenate (Emp)

LOAD

[Reporting To] AS EmpID,

DivisionalHead AS [Reporting To],

[Reporting To] AS Name,

Department

Resident Emp

WHERE [Reporting To]='VACANT';

[aveeeeeee7en]

Thanks Sergey

It Works.