4 Replies Latest reply: Sep 11, 2018 2:28 AM by Arvind Patil RSS

    How to do where not exists with compositekey

    harish k

      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.