Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a table looking something like this:
EmployeeId | EmployeeName | ManagerId |
1 | John Doe | 2 |
2 | Jerry Johnson | 0 |
3 | Jane Doe | 2 |
Jerry is John and Jane's manager but instead of id, I would like to add a calculated column ManagerName. So something like add EmployeeName from row where EmployeeId = ManagerId. How can I achieve this? I am completely new att Qlik Sense but can't seem to find any answers to this.
Thank you!!
@mmhw try below
Data:
LOAD EmpID,
EmpName,
MgrID
FROM table;
left join(Data)
LOAD EmpID as MgrID,
EmpName as MgrName,
resident Data;