Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I limit the load of data in one file based on the content of another table?

I have a file that contains all clients and am loading a tabe that contains all trades and I only want to load the clients if they have traded with us. The client ID appears in both the client file and the trade file.

How do I do this?

11 Replies
Not applicable
Author

hi - tried it and am getting an error. Oracle may not like that syntax. Any ideas?

pover
Partner - Master
Partner - Master

Exists() is not an Oracle function so doing will not work.

Oracle_Table:

Load * ;

SQL Select *

From ...

Where not exists(..);

Since it is a QV function you should put the where not exists below the load

Oracle_Table:

Load *

Where not exists(..);

SQL Select *

From ...;

Karl