topic Re: Joining two tables in QlikView

Joining two tables

ajsjoshua — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I am finding difficulties while joining this two tables

Payment:

Load

Company&'_'&if(left(CardCode,1)=0,mid(CardCode,2,15),CardCode) as Payment_QVLink_CustomerKey,

U_Export

FROM

(qvd) where Canceled='N';

left join

PaymentCustomer:

LOAD Company&'_'&if(left(CardCode,1)=0,mid(CardCode,2,15),CardCode) as Payment_QVLink_CustomerKey,

U_ATBeatCode,

U_BeatCode

FROM

(qvd)

where CardType='C';

When i join only from and i am getting data for the field U_ATBeatCode but when i join from and i am not getting data for the field U_ATBeatCode

Regards,

Joshua.

Re: Joining two tables

shiveshsingh — Tue, 17 Apr 2018 07:11:01 GMT

Hi, can you try this?

Payment:

Load

Company&'_'&if(left(CardCode,1)=0,mid(CardCode,2,15),CardCode) as Payment_QVLink_CustomerKey,

U_Export

FROM

(qvd) where Canceled='N';

left join

PaymentCustomer:

LOAD Company&'_'&if(left(CardCode,1)=0,mid(CardCode,2,15),CardCode) as Payment_QVLink_CustomerKey,

U_ATBeatCode,

U_BeatCode

FROM

(qvd)

where CardType='C';

Re: Joining two tables

ajsjoshua — Tue, 17 Apr 2018 07:29:41 GMT

Dear Shivesh,

I tried as u suggested i am not getting data for the field U_ATBeatCode.

Actually the U_ATBeatCode field has data only for the tables OCRD_SL,OCRD_TM.

U_ATBeatCode has no data for the tables OCRD_UA,OCRD_SA,OCRD_LA.

Regards,

Joshua.

Re: Joining two tables

shiveshsingh — Tue, 17 Apr 2018 07:35:18 GMT

Hi Joshu

if you don't have values in OCRD_UA,OCRD_SA,OCRD_LA. tables, why do you want to load data from these tables.

It's better to direct pull the values from OCRD_SL,OCRD_TM.

It may be due to Payment_QVLink_CustomerKey . . . Is this value unique for all the tables?

Re: Joining two tables

ajsjoshua — Tue, 17 Apr 2018 07:42:27 GMT

Dear Shivesh,

In future there will be values for OCRD_UA,OCRD_SA,OCRD_LA.

Some times in the filed U_ATBeatCode same values will be there in one or two tables.

Regards,

Joshua.

Re: Joining two tables

shiveshsingh — Tue, 17 Apr 2018 09:51:16 GMT

Hi Joshua

Please check the value of Payment_QVLink_CustomerKey key for these tables once. can u share the app?

Re: Joining two tables

ajsjoshua — Tue, 17 Apr 2018 10:58:03 GMT

Hi Shivesh ,

Instead of left join i tried join now U_ATBeatCode is coming

if(len(U_ATBeatCode)<>0,U_ATBeatCode,'') as U_ATBeatCode,

now when i load

Paymentdetails:

load

if(U_Export='Y',Company&'_'&Upper(U_ATBeatCode),if(U_Export='N',Company&'_'&Upper(U_BeatCode ))) as Payment_QVLink_BeatKey

Resident Payment;

drop table Payment;

Payment_QVLink_BeatKey doesn't comes when i select U_Export='Y in list box.'

Re: Joining two tables

shiveshsingh — Tue, 17 Apr 2018 11:14:11 GMT

Can u share the app?