How to do where not exists with compositekey

[Anonymous]

LOAD  TransID,

     supplier_code ,

     customer_code

     customer_code& '|'& supplier_code as  CustKey,

from Transaction;

LOAD  CustID,

     supplier_code ,

     customer_code

     customer_code& '|'& supplier_code as  CustKey,

from Customer;

1.These are two table i want to do where not exists for these two table.

2.and also i want to know the logic for frontend with out  using wherenot exists in backend.

[arvind_patil]

Hi Harish,

Try Below:

Transaction1:

LOAD  TransID,

     supplier_code ,

     customer_code

     customer_code& '|'& supplier_code as  CustKey,

from Transaction;

Customer1:

LOAD  CustID,

     supplier_code ,

     customer_code

     customer_code& '|'& supplier_code as  CustKey,

from Customer;

Transaction:

LOAD  TransID,

     supplier_code ,

     customer_code

      CustKey,

Resident  Transaction1;

Drop Table Transaction1;

Concatenate

Customer:

LOAD  CustID,

     supplier_code ,

     customer_code

     CustKey,

Resident Customer1 where Not Exists(CustKey,CustKey);

Drop Table Customer1 ;

Then you will get non common fields only.

Thanks,

Arvind Patil

[Anonymous]

Thanks Arvind

[Anonymous]

Can you please Explain How to do that logic in Front end

[arvind_patil]

Please mark it if it is solve your purpose . so it help others too

Thanks,

Arvind Patil