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

[andrespa]

Hi, you can try concatenate between both tables.

[Anonymous]

Instead of join use Concatenate .

[master_student]

Could you explain to me how qlikview do the join by default?

Thanks

[qlikview979]

Hi,

you  can try with concatenate. or else share your data

Regards,

Mahesh.

[ramasaisaksoft]

Hi Master,

By default QV fallows Full outer Join & Concatenate

[Anonymous]

Follow this Attachment . It is really helpful

[andrespa]

QW by default do a full outer Join, wich is what concatenate does and what probably you would need.

You could read this one, is a pretty good article about it.

Understanding Join, Keep and Concatenate

Hope it helps,

Andrés

[master_student]

noConcatenate

SUIVI_DA:

load

LB,

LBopex,

CDR,

NUM_DA,

Mnt DA

resident xxxx;

Budget:

load

LB,

LBopex,

budget po

RESIDENT ccc;

I thought in qlik when we have the same LB and CDR, QV wil put theme in the same line but see below :

[andrespa]

That's because even if those two fields have the same value, DA_STATUS, and DA_NUM are different ones.