Discussion Board for collaboration on QlikView Scripting.
I have a table.
Need result with ManagerNames
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;
View solution in original post
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
LOAD Emp_id, Emp_Name from Source;
Qlik Community Tip: Marking Replies as Correct or Helpful