topic Re: Link Table not joining field with same name in QlikView

Link Table not joining field with same name

lessassy — Tue, 26 Nov 2019 14:55:33 GMT

Hello everyone,

My Link Table is the following one:

LINKTABLE:
LOAD DISTINCT
$LK_KPI_SRV,
COD_KPI,
COD_KPI_CDG,
COD_AGE,
COD_DEP_TER,
COD_SRV
RESIDENT D_OBJECTIF;

Concatenate (LINKTABLE:)

LOAD Distinct

$LK_KPI_SRV,
COD_DEP_TER,
COD_AGE,
COD_KPI_CDG,
COD_KPI,
COD_SRV,
ID_KPI_COD_SRV_SEC

RESIDENT F_OBJECTIF;

Concatenate (LINKTABLE:
FAIT:
LOAD Distinct
$LK_KPI_SRV,
COD_DEP_TER,
COD_AGE,
COD_KPI,
COD_KPI_CDG,
COD_SRV,
ID_KPI_COD_SRV_SEC
RESIDENT F_RESULTAT;

Concatenate (FAIT)

LOAD Distinct

$LK_KPI_SRV,
COD_KPI
Resident F_KPI;

But some reason i can't manage to join the data within the table "F_KPI" with the rest of the model.

My F_KPI table is the following one:

F_KPI:
LOAD
COD_KPI,
COD_KPI as $LK_KPI_SRV,
COD_DAT,
COD_SOC,
FLG_REA,
PCT_REA,
VAL_KPI
Resident TEMP_F_KPI_1;
Drop Table TEMP_F_KPI_1;

And basically i want to associate some attribute from the D_OBJECTIF table with the field VAL_KPI which represents an objective to obtain.

ANd i don't know what i did wrong with the link table

PS: i attached a picture of my datamodle.

The name oif my link tablke is fact but the field are the same

Re: Link Table not joining field with same name

Vengatesh — Wed, 27 Nov 2019 06:32:38 GMT

Once you concatenate FAIT table with LinkTable, then it will come under LinkTbale only.

Just change the table name in concatenate function:

Concatenate (LinkTable)

LOAD Distinct

$LK_KPI_SRV,
COD_KPI
Resident F_KPI;

Re: Link Table not joining field with same name

Brett_Bleess — Mon, 09 Dec 2019 22:22:27 GMT

If the other post helped you get what you needed, be sure to come back to the thread and use the Accept as Solution button on that post to give credit for the assistance and let other Community Members know that worked.

I am including a Design Blog link as well with some additional information that may be useful to you:

https://community.qlik.com/t5/Qlik-Design-Blog/Concatenate-vs-Link-Table/ba-p/1467569

Regards,
Brett

Re: Link Table not joining field with same name

qliksus — Tue, 10 Dec 2019 06:07:37 GMT

Your datamodel has the table F_KPI connected to rest of model using K_KPI_SRV , whats the issue here ?