Annapurna1
Contributor III
2022-06-02
09:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 |
454 Views
1 Solution
Accepted Solutions
vinieme12
Champion III
2022-06-02
10:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
If a post helps to resolve your issue, please accept it as a Solution.
436 Views
2 Replies
vinieme12
Champion III
2022-06-02
10:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
If a post helps to resolve your issue, please accept it as a Solution.
432 Views
vinieme12
Champion III
2022-06-02
10:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
If a post helps to resolve your issue, please accept it as a Solution.
437 Views