topic Re: Multiple table join in QlikView

Multiple table join

calvin_wee — Mon, 03 Apr 2017 20:22:10 GMT

Hi,

I am having 2 sets of data that I need to join them but not able to get the join right.

Load Table A

Left Join Table B

Concatenate Table C

Left Join Table D

Joining Table A, B, C is successful but when I LEFT JOIN Table D, all the data in D is loaded instead of Left Join.

Any Advise?

Thanks in Advance.

Re: Multiple table join

hector_munoz — Mon, 03 Apr 2017 21:02:35 GMT

Hi Calvin,

Could you attach the script sentences?

Regards,
H

Re: Multiple table join

calvin_wee — Tue, 04 Apr 2017 01:26:43 GMT

Hi,

Thanks for your reply. Please see below simplified form:

LOAD PRNo,

PONo,

Approver1;

[PRPO Information]

[SQL A]

left join ([PRPO Information])

LOAD Plant,
     CRFNo,
     PRNo,
     PRId,
     RequestorID,
     Requestor,
     RequestorMAIL,
     CostCtr,
     CostCtrName,
     Stage,
     BuyerCode,
     Buyer,
     PRDesc,
     VendorCode,
     VendorName,
     PRSubmitDT,
     InSystem;

[SQL B]

Concatenate

[SQL C]

LOAD PRNo,
     CALRequired,
     MCFRequired;

left join ([PRPO Information])

[SQL D]

Re: Multiple table join

hector_munoz — Tue, 04 Apr 2017 05:56:31 GMT

Hi Calvin,

Is hard for me to see where is the problem without the full code. Maybe the problem is in some part of [SQL D]...

Regards,

Re: Multiple table join

Kushal_Chawda — Tue, 04 Apr 2017 07:43:11 GMT

try like below

[PRPO Information]:

LOAD PRNo,

PONo,

Approver1;

[PRPO Information]

left join ([PRPO Information])

Concatenate ([PRPO Information])

left join ([PRPO Information])

LOAD *

FROM Source D;

Not sure about below part

[SQL C]

LOAD PRNo,
CALRequired,
MCFRequired;

Multiple table join

Re: Multiple table join

calvin_wee — Tue, 11 Apr 2017 09:37:14 GMT

What happened is that when I commented the last statement and stops at SQL C, the data is correct.

When I continue with SQL D, instead of Left Join, I get 100% of SQL D data that is not desired.

Somehow it has become Right Join.

Re: Multiple table join

calvin_wee — Wed, 12 Apr 2017 02:19:43 GMT

Thank you all for your valuable inputs.

We managed to resolve as the wrong was putting LOAD before JOIN.

Once changed to JOIN then LOAD, it is ok.