Logic

[Annapurna1]

Hi Team,

I am having below table,

(EmpID, Name, ManagerID) where Manager of Anand is Akash and the Manager of Praveen is Anand and so on..-- But i  want to show one more column ManagerName.

Please help me out to solve this.

EmpID	Name	ManagerID
1	Anand	3
2	Praveen	1
3	Akash	4
4	Mahesh	2

[vinieme12]

Main:

load EmpId,Name, ManagerId 

From xyzsource;

Left Join(Main)

Load EmpId as ManagerId,Name as ManagerName 

Resident Main;

[vinieme12 · Accepted solution]

kindly close the thread by marking a response as solution