Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
mwallman
Creator III
Creator III

How to load a file that contains orders to be excluded from the main orders table?

Hello,

In my data model I have an Orders table (customer orders transactions data).

Some of the orders are error or historical that should be excluded.

The users send us an excel file containing the orders to exclude.

For example:

Orders table:

  

OrderIDItemNoQuantity
22314545
2232434
43314545
224164
224223
434123
225123

Orders to exclude:

  

OrderIDItemNoQuantity
224164
224223
434123

How do you set-up an exclusion file so that these orders are excluded from the Orders table?

2 Replies
tresesco
MVP
MVP

Try with exists() like:

Exclude:

Load OrderID from <>;

FactTable:

Load * from <> where not exists(OrderID);

sunny_talwar

Do you need exclusion just based on OrderID or OrderID and ItemNo? For both, you can try this

Exclude:

Load OrderID&ItemID as OrderItemKey from <>;

FactTable:

Load * from <> where not exists(OrderItemKey, OrderID&ItemID);