Link Table not joining field with same name

[lessassy]

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

[Vengatesh]

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;

[Brett_Bleess]

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

[qliksus]

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