Link Manager ID back to Employee ID

[Anonymous]

I have the following:

LIB CONNECT TO 'Production Head Count';

LOAD EmpNum,

    Emplname,

    Empfname,

    RegTemp,

    JobType,

    EmpType,

    RptMgr,

    orgGroup1,

    orgName,

    Country,

    City,

    Email,

    Coeuser;

SQL SELECT EmpNum,

    Emplname,

    Empfname,

    RegTemp,

    JobType,

    EmpType,

    RptMgr,

    orgGroup1,

    orgName,

    Country,

    City,

    Email,

    Coeuser

     FROM HCT.dbo."Emp_Data"

The RptMgr is the EmpNum of the manager..

I would like  to link it back to the table to get the EmplName for the manager.

I know in Microsoft Access I would just duplicate the table and  join  RptMgr to the EmpNum. 

How might that be done in Qliksense?

[ogster1974 · Accepted solution]

What you need to use is the apply map function this Article will help you understand its use.

https://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Regards

Andy

[tomasz_tru]

If there's more than two hierarchy levels, use: Loading hierarchy data ‒ Qlik Sense

Tomasz