join

[#1]

hello all,

       i need to join the below tables such that transdate of 1st table matches transdate of 2nd,MID of 1st table matches 2nd,tid of 1st table matches 2nd uploaddate of 1st table matches with 2nd.

[SunilChauhan]

i thing you should simply use

Inner join between them

Load

from firsttable

inner join

load from seond table

hope this helps

[SunilChauhan]

on emor thing you can do

Tab1:

Load  *,

Transdate&Mid&Tid&Uploaddate as key

from table1

Tab2;

Load

*

from

where FlnalStatus<>'Close' and exist(key,Transdate&Mid&Tid&Uploaddate);

Drop table Tab1;

try implementing logic on this

hope this helps

[#4]

Hi,

If you want join this tables by using three common fields means. Should create composite Key. Otherwise qlikview will create the synthetic keys.

CCfirstcutmaster:

Load

TranDate &'-' & MID &'-' & TID &'-' & UPLOADDATE as CompKey,

Remaining fieldnames

from CCfirstcutmaster.qvd;

Load

TranDate &'-' & MID &'-' & TID &'-' & UPLOADDATE as CompKey,

Remaining fieldnames

from Transaction.qvd;

in this scenario this two table will join based on CompKey

Hope this will help you...

[#5]

Rajasekhar Reddy Mk: I disagree with your previous reply. You can without problems, join 2 tabes based on 3 key-fields without making a composite key. Note, it is not wrong to make a composite key, but also it is not required: when there are 3 key fields,Qlikview will join based on these 3 fields. And because you performe a join, there will not be a synthetic key or table because the join combines these 2 tables into 1.