How to take record in table but not in another table even it have a few records same in both

[huytran]

Hi Qlik community,

I'd like to ask a question: I have a 3 data tables which were load to Qlik sense app.

           + Table Vendor:

           + Table AllInfo:

            + Table Cost:

I want to create a table which is existed in table Vendor but not in table cost. Result below:

 Do you have any ideas how I can do?

Thanks.

[jonathandienst]

Perhaps like this:

Incl:
LOAD distinct JobNUmber as InclJobNumber
From Vendor;

Excl:
LOAD distinct JobNumber as ExclJobNumber
From Cost;

All:
LOAD Enquiry, JobNumber, Amount, RID, Type
FROM AllInfo
Where Exists(InclJobNumber, JobNumber) 
	And Not Exists(ExclJobNumber, JobNumber);
	
DROP Table Incl, Excl;

If you need to apply this logic to both the JobNUmber and Enquiry fields, then use a concatenation in the Incl and Excl loads and in the exists statements.