Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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!

Tags (2)