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

Loading data if it does not exist in another table

I'm trying to figure out how to Load all records from a QVD file where a RequestID is not in another QVD file.

Example:

Load %RequestID, *

From ..\DATA\Projects.qvd (qvd)

Where Not %RequestID In TempTable.qvd;

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try something like this:

TableA:

load %RequestID

From TempTable.qvd (qvd);

TableB:

Load %RequestID, *

From ..\DATA\Projects.qvd (qvd)

Where Not exists(%RequestID) ;

Drop table TableA;


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Try something like this:

TableA:

load %RequestID

From TempTable.qvd (qvd);

TableB:

Load %RequestID, *

From ..\DATA\Projects.qvd (qvd)

Where Not exists(%RequestID) ;

Drop table TableA;


talk is cheap, supply exceeds demand
Not applicable
Author

That worked! I only modified Exists() to include both the alias and actual field name as shown below.

Exists(%RequestID, REQUEST_ID)

Thank you!