Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
lessassy
Creator
Creator

Link Table not joining field with same name

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

3 Replies
Vengatesh
Partner - Creator
Partner - Creator

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;

You Know What To Do.
Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
qliksus
Specialist II
Specialist II

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