How to link tables the way I want them to link?

[#1]

Here is part of my script I loaded into Qlikview:

SQL SELECT DESCRIPTION,
IDENTIFIER,
"PMID_H0",
"MS_STATUSID",
MID
FROM IKSDB.TBEQUIPMENT
Where ("MS_STATUSID" = '14');

SQL SELECT MSID,
MID,
STATUSID
FROM IQREVDB.TBMSTRATEGY
Where (STATUSID = '6');

SQL SELECT MSID,
TITLE,
"CP_TASK",
"CP_TASK_DESC",
"CP_TASK_FREQ",
"CP_TASK_FREQ_UNITID",
TASKTYPE,
"TASK_FREQ",
"TASK_FREQ_UNIT_ID" as "UNIT_ID"
FROM IQREVDB.TBMSTRATEGYTASKS;

SQL SELECT "UNIT_ID",
UNIT,
DESCRIPTION,
"DAYS_CONVERTED"
FROM IQREVDB.TBUNITS;

I want the tables to link the tables by MID, MSID, and "UNIT_ID". When I load this script, Qlikview automatically links MID, MSID, and DESCRIPTION. What do I need to do to accomplish this? I got the links I wanted when I commented-out one of the DESCRIPTIONS, but that takes away from my data...

[swuehl · Accepted solution]

rename one of your DESCRIPTION fields using AS

[santiago_respane]

Hi,

es Stefan said you will solve your issue by renaming the DESCRIPTION field using AS.

But besides that i would like to share with you a basic guideline about composite keys in QlikView, they generate synthetic keys that should be avoided.

I recommend you to read the following article:

Synthetic Keys

Concatenate or Link Table?

Hope this helps.

Kind regards,