Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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!

0 Replies