0 Replies Latest reply: Jun 5, 2015 11:02 PM by Wyatt Conrad RSS

    One to Many Help

      Ok, I'm new to Qlik Sense and have been trying to figure out how to properly link my technician table to multiple other tables such as the Cases and Sessions I have listed below. The data to start was pretty messy so I've used ApplyMap() to the cases and sessions table to use the TechnicianID rather than their login, email address, or name. So, I think I'm close but I haven't found the right solution to make this work. I also have two more tables that contain createdby and other similar fields that I need to link to.

       

      Technicians:


      TechnicianID

      TechnicianLoginTechnicianName
      123345login1Smith, John
      324546login2Smith, Jane

      Cases:

      CaseIDCreatedByModifiedByCurrentOwner
      1123345324546324546
      2324546123345123345

      Sessions:

      SessionIDCreatedByModifiedBy
      4324546123345
      5123345324546

       

      Here is an abbreviated sample of the load script I'm using for the Cases table (the Cases table initially had the technicianlogin in createdby, modifiedby and currentowner):

      Technicians:

      LOAD

          TechnicianID,

          TechnicianName,

          TechnicianLogin,

          TechnicianEmail,

          Site,

          Coach,

          LOB

      FROM ...;

       

      TechniciansByLogin:

      Mapping LOAD

          TechnicianLogin,

          TechnicianID

      Resident Technicians Order By TechnicianID;

       

      Cases:

      LOAD

      ...

          ApplyMap('TechniciansByLogin',[Created by],'Undefined') as CreatedBy,

          ApplyMap('TechniciansByLogin',[Modified by],'Undefined') as ModifiedBy,

          ApplyMap('TechniciansByLogin',[Current Owner],'Undefined') as CurrentOwner

      FROM ...

       

      Any help is appreciated!