Table join

[vikasgupta]

Hi Everyone

we wants to join Loc Master to transaction table table name is Loc and Txnd we required two field from loc master LocCd (location code) and ( location Type) LocTyp and Loc master is already join in our data model so we are doing Left join of required field . Our SQL expression is the following:-

join loc on (LocCd=TdFrRmLoc or LocCd=TdtoRmLoc) 
We are using following QlikView script :-

Left Join
load
     LocCd As TdFrRmLoc,
     LocTyp as  TdFrLocTyp
FROM
[..\QVD\LocationMaster.Qvd]
(qvd);

Left  Join
load
   LocCd As TdToRmLoc,
   LocTyp as  TdToLocTyp

FROM
[..\QVD\LocationMaster.Qvd]
(qvd);

We run SQL script join loc on (LocCd=TdFrRmLoc or LocCd=TdtoRmLoc) in SQL server we are getting  2222624 records in Qlikview we are getting 2659256 records.

The original  no. of records in TXND table is 2659256 and in Loc master 63 records .

Thanks

Vikas Gupta

[sujeetsingh]

Try it with LOAD DISTINCT

[vikasgupta]

Hi

I tried with load distinct but still i am getting  same number of record .I just wants to apply  this SQL script

join loc on (LocCd=TdFrRmLoc or LocCd=TdtoRmLoc)  in Qlikview script .

Thanks

Vikas Gupta

[sujeetsingh]

Vikas ,

we do not join like sql ...

yes if you want to join two tables on basis of TdtoRmloc...

Join (table1)

Load 

TdtoRmloc

----

----

resident Table2;

But yes note that Table one and Table2 should have only  TdtoRmloc as coomman field nothing else...

If there are some comman fields RENAME them.