Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
MVP & Luminary
MVP & Luminary

Re: Loading data if it does not exist in another table

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
2 Replies
MVP & Luminary
MVP & Luminary

Re: Loading data if it does not exist in another table

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
Not applicable

Re: Loading data if it does not exist in another table

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

Exists(%RequestID, REQUEST_ID)

Thank you!