Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude Multiple Records in Script

I have a problem that doesn't seem too complicated but I just can't figure it out. I have two Excel files, one with all of my product data and one that is just a list of products that I need to exclude from the data. Example:

DATA_TABLE:

Product#, Name, Inventory

1001, A, 500

1002, B, 600

1003, C, 200

1004, D, 700

1005, E, 900

1006, F, 100

1007, G, 200

EXCLUSIONS_TABLE:

Product#

1001

1004

1005

From what I've searched for on the boards, WHERE NOT looks like it is the solution for excluding a few items in the script, but I have a lot more than just a few exclusions and they may change from week to week.

Any help would be greatly appreciated.

Thanks!

-- Justin

1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Load your exclusions first and give the field a unique name (like ExcludedProduct).

Then use the following condition in your main data load:

WHERE NOT EXISTS(ExcludedProduct, Product)

View solution in original post

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Load your exclusions first and give the field a unique name (like ExcludedProduct).

Then use the following condition in your main data load:

WHERE NOT EXISTS(ExcludedProduct, Product)

Not applicable
Author

It worked! Thanks, Oleg!