Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
help4qv123
Creator II
Creator II

Need Help

Hi all,

I have a table.

Need result with ManagerNames

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

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;


Capture1.JPG

View solution in original post

6 Replies
t_chetirbok
Specialist
Specialist

Hello!

Find the attachment

help4qv123
Creator II
Creator II
Author

Thank You..My actual table has more than 2 columns...i cant use apply map function. is there any other way without using applymap..

t_chetirbok
Specialist
Specialist

for creating Map you need just write your two field from all data

MAP:

Mapping

LOAD  Emp_id, Emp_Name from Source;

settu_periasamy
Master III
Master III

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;


Capture1.JPG

View solution in original post

help4qv123
Creator II
Creator II
Author

Thank You...:)