Join / Lookup

[george55]

Hi all,

Have to do a Lookup to find out the Name of the case handler. Each case handler has an abbreviation (KURZZEICHEN) and all specific details are locatated in Table "SB".

The Table "PE" has order information. Each order has one case handler and two contact persons. The abbreviations of the contact persons are located in Table "ST". All Details of contact persons and case handlers are in the Table "SB".

Goal:

Would like to do a Lookup to find out which person has the specific abbreviations (Table "ST" ST_KURZZEICHEN1 & ST_KURZZEICHEN2) from Table "SB".

Would like to have an output with all Dimensions information in one table. With this Data Model I get an cartesian product. Thank you for your help.

[dwforest]

If you just need one column from SB look at Mapping Tables

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

[george55 · Accepted solution]

Didn't work for me, still got a cartesian product.

Created a new Table. This worked:

SBNEW:
Load
     SB_KURZZEICHEN AS SBNEW_KURZZEICHEN1,
     SACHBEARBEITER_ID AS SBNEW_SACHBEARBEITER_ID1,
Resident SB;