Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

harikumar
New Contributor

How to do where not exists with compositekey

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.

4 Replies
arvind_patil
Valued Contributor II

Re: How to do where not exists with compositekey

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

harikumar
New Contributor

Re: How to do where not exists with compositekey

Thanks Arvind

harikumar
New Contributor

Re: How to do where not exists with compositekey

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

arvind_patil
Valued Contributor II

Re: How to do where not exists with compositekey

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

Thanks,

Arvind Patil