Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a table.
Need result with ManagerNames
Hi,
Try this..
T1:
LOAD * INLINE [
Emp_id, Emp_Name, Manager_id
1, A, 1
2, B, 1
3, C, 2
4, D, 3
5, E, 3
6, F, 4
7, G, 5
];
Left Join(T1)
LOAD Emp_id as Manager_id,Emp_Name as Manager_Name Resident T1;
Hello!
Find the attachment
Thank You..My actual table has more than 2 columns...i cant use apply map function. is there any other way without using applymap..
for creating Map you need just write your two field from all data
MAP:
Mapping
LOAD Emp_id, Emp_Name from Source;
Hi,
Try this..
T1:
LOAD * INLINE [
Emp_id, Emp_Name, Manager_id
1, A, 1
2, B, 1
3, C, 2
4, D, 3
5, E, 3
6, F, 4
7, G, 5
];
Left Join(T1)
LOAD Emp_id as Manager_id,Emp_Name as Manager_Name Resident T1;
Thank You...:)