Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Annapurna1
Contributor III
Contributor III

Logic

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
Labels (1)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

kindly close the thread by marking a response as solution

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

Main:

load EmpId,Name, ManagerId 

From xyzsource;

 

 

Left Join(Main)

Load EmpId as ManagerId,Name as ManagerName 

Resident Main;

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

kindly close the thread by marking a response as solution

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.