Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, you can try concatenate between both tables.
Instead of join use Concatenate .
Could you explain to me how qlikview do the join by default?
Thanks
Hi,
you can try with concatenate. or else share your data
Regards,
Mahesh.
Hi Master,
By default QV fallows Full outer Join & Concatenate
Follow this Attachment . It is really helpful
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
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 :
That's because even if those two fields have the same value, DA_STATUS, and DA_NUM are different ones.