topic Re: Help With Join Qvd in QlikView

Help With Join Qvd

ariel_klien — Thu, 25 Jul 2013 07:37:20 GMT

Hello all,

I need help with Join 2 QVD:

Qvd1:

Field1	Field2	Field3
1	A	11
2	B	22
3	C
4	D

Qvd2:

Field1	Field2	Field3
1	A	11
3	C	33
4	D	44

i need that the join tables will show:

Field1	Field2
1	A	11
2	B	22
3	C	33
4	D	44

i tried:

LOAD Fieild1
Fieild2,

Fieild3
FROM qvd1.qvd (qvd);

left Join

LOAD Fieild1
Fieild2,

Fieild3

FROM qvd2.qvd (qvd);

but it duplicate the records (2 raws for line 3 & 2 raws for line 4)

any idea?

Ariel

Re: Help With Join Qvd

kaushiknsolanki — Thu, 25 Jul 2013 07:42:06 GMT

HI,

Try this.

LOAD Fieild1
Fieild2,

Fieild3
FROM qvd1.qvd (qvd);

left Join

LOAD Fieild1
Fieild2,

Fieild3

FROM qvd2.qvd (qvd) where not exists(Fieild1,Fieild1);

Regards,

Kaushik Solanki

Re: Help With Join Qvd

ariel_klien — Thu, 25 Jul 2013 08:19:38 GMT

Hi Kaushik

Thank for you Answer

this is my real script - I tried your suggestion but it didn't work.

Key:

LOAD Deposit_Request_Key,

Account__c,

Fund_Key

FROM 1.qvd (qvd);

left Join

LOAD Deposit_Request_Key,

Account__c,

Fund_Key

FROM 2.qvd (qvd) Where not exists(Fund_Key) ;

Any Idea?

Ariel

Re: Help With Join Qvd

kaushiknsolanki — Thu, 25 Jul 2013 08:25:14 GMT

Hi,

Try below script.

Key:

LOAD Distinct Deposit_Request_Key,

Account__c,

Fund_Key

FROM 1.qvd (qvd);

Concatenate

LOAD Distinct Deposit_Request_Key,

Account__c,

Fund_Key

FROM 2.qvd (qvd) Where not exists(Fund_Key) ;

Regards,

kaushik Solanki

Re: Help With Join Qvd

ariel_klien — Thu, 25 Jul 2013 08:27:15 GMT

Still the same result.

not working.

Re: Help With Join Qvd

kaushiknsolanki — Thu, 25 Jul 2013 08:28:16 GMT

Hi,

You must change the Fund_Key to Deposit_Request_Key.

Regards,

Kaushik Solanki

Re: Help With Join Qvd

ariel_klien — Thu, 25 Jul 2013 08:38:03 GMT

Hi,

I change it and i Changed the order of the QVDs..

Key:

LOAD Deposit_Request_Key,

Account__c,

Fund_Key

FROM 2.qvd (qvd);

Concatenate

LOAD Deposit_Request_Key,

Account__c,

Fund_Key

FROM 1.qvd (qvd) Where not exists(Deposit_Request_Key) ;

Now it is working fine

Thanks

Ariel