Join

[master_student]

Hello,

I have two tables budget and DA that have 2 columns in commun CDR and LB, a synthetic table was creates automatically by qlikview

the result of that join is only the commun values will appear? because I need all values of those fields in the two tables.

Thanks

[master_student]

I forget to add it in the script, see bellow my data model :

[Anonymous]

Looks like there are 2 options :

Either use a left join of SUIVI_DA and budget_fct or create a generic key like

CDR & '-' & LBopex & '-' & LB in both SUIVI_DA and budget_fct tables.  Make sure not to load CDR, LPopex and LB individually in the budget_fct table, or QV will continue creating the syntethic key.

[Anil_Babu_Samineni]

Try to share the QVW, So that we can figure out the SK's

[master_student]

Hello, I tried your solution, I have used a link table,

a question : only common fiels between those tables are displayed because I need to display all rows:

here's my link tab :

linktab:

load distinct

KEY,

LB,

CDR,

LBopex

resident SUIVI_DAA;

join

load distinct

KEY,

LB,

CDR,

LBopex

resident budget;

join

load distinct

KEY,

LB,

CDR,

LBopex

resident F2_DA_BC;

drop fields LB,CDR,LBopex from SUIVI_DAA,budget, F2_DA_BC;

Thanks for your support.

Wiem