Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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;
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;
That worked! I only modified Exists() to include both the alias and actual field name as shown below.
Exists(%RequestID, REQUEST_ID)
Thank you!