topic Loading data if it does not exist in another table in QlikView

Loading data if it does not exist in another table

Thu, 03 Oct 2013 15:45:00 GMT

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 — Thu, 03 Oct 2013 15:53:23 GMT

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;

Thu, 03 Oct 2013 17:55:06 GMT

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

Exists(%RequestID, REQUEST_ID)

Thank you!