I'm trying to figure out how to Load all records from a QVD file where a RequestID is not in another QVD file.
Load %RequestID, *
From ..\DATA\Projects.qvd (qvd)
Where Not %RequestID In TempTable.qvd;
Try something like this:
From TempTable.qvd (qvd);
Where Not exists(%RequestID) ;
Drop table TableA;
That worked! I only modified Exists() to include both the alias and actual field name as shown below.
Retrieving data ...