Loading data if it does not exist in another table

[#1]

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;

[Gysbert_Wassenaar · Accepted solution]

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;

[#3]

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

Exists(%RequestID, REQUEST_ID)

Thank you!