Help With Join Qvd

[ariel_klien]

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

[kaushiknsolanki]

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

[ariel_klien]

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

[kaushiknsolanki]

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

[ariel_klien]

Still the same result.

not working.

[kaushiknsolanki]

Hi,

     You must change the Fund_Key to Deposit_Request_Key.

Regards,

Kaushik Solanki

[ariel_klien · Accepted solution]

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