Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
Need to set the Employees in Tree Structure who have VACANT Manager Name based on the MANAGER_POS
Regards
Aviral
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';
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
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???
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';
Thanks Sergey
It Works.