Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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

View solution in original post

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!