2 Replies Latest reply: Jul 19, 2017 4:05 PM by Tomasz Truszkowski RSS

    Link Manager ID back to Employee ID

    jim Van lanen

      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?