Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Thanks Arvind
Can you please Explain How to do that logic in Front end
Please mark it if it is solve your purpose . so it help others too
Thanks,
Arvind Patil