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]

is there anyway to correct that?

thanks

[MindaugasBacius]

Use one fact table if both tables are needed:

Data :

load

     LB,

     LBopex,

     CDR,

     NUM_DA,

     Mnt DA,

     SUIVI_DA as Table

resident xxxx;

Concatenate

load

     LB,

     LBopex,

     budget po,

     Budget as Table

RESIDENT ccc;

[Anonymous]

Hi,

When I look at your script, I can see that only field 'LB' is in common, not 'LB' and 'CDR' :

noConcatenate

SUIVI_DA:

load

LB,

LBopex,

CDR,

NUM_DA,

Mnt DA

resident xxxx;

Budget:

load

LB,

LBopex,

budget po

RESIDENT ccc;

Can you share your datamodel with us ?

[andrespa]

Use concatenate

SUIVI_DA:

load

LB,

LBopex,

CDR,

NUM_DA,

Mnt DA

resident xxxx;

CONCATENATE

Budget:

load

LB,

LBopex,

budget po

RESIDENT ccc;

[qlikview979]

Hi,

You can use  Concatenate

Data :

load

     LB,

     LBopex,

     CDR,

     NUM_DA,

     Mnt DA,

     SUIVI_DA as Table

resident xxxx;

Concatenate

load

     LB,

     LBopex,

     budget po,

     Budget as Table

RESIDENT ccc;

[master_student]

I use the concatenate option and still have the same pb. this is because as you said before qv by defaut concatenate tables..

[andrespa]

Well, you could go for a key. Something like this might be useful: 

Data :

load

     LB &'_'&LBopex               AS KEY,    

     LB,

     LBopex,

     CDR,

     NUM_DA,

     Mnt DA,

     SUIVI_DA as Table

resident xxxx;

LEFT JOIN

load

     LB &'_'&LBopex               AS KEY,

     LB,

     LBopex,

     budget po,

     Budget as Table

RESIDENT ccc;

[MindaugasBacius]

Simple use left join without Key. By default the key is going to be LB and LBopex fields.

[master_student]

I did as you recommended but the column comming from the budget file was removed

[MindaugasBacius]

Try Outer Join then.