

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Comparing unique ID's in incremental script Qlik sense
how to compare unique id's in qvd with DB.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The Exists function works by comparing existing fields. If you want to find ID's that are in the QVD but not in the database, you will want to load the IDs from the database and then from the QVD
CurrentIDs:
load ID
from DB;
MissingIDs:
load ID as MissingID
From QVD Where Not Exists(ID);
The values in MissingID should be in the QVD but not in the database.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You might be able to use the Exists() function. For example, if you want to load only new ID's you could use the Exists function in the where clause.
load ID
Where Not Exists(ID);


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please Help with example script.
I need to take ID's which are removed from DB but available in QVD.
how to get ID's which are not available in DB.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The Exists function works by comparing existing fields. If you want to find ID's that are in the QVD but not in the database, you will want to load the IDs from the database and then from the QVD
CurrentIDs:
load ID
from DB;
MissingIDs:
load ID as MissingID
From QVD Where Not Exists(ID);
The values in MissingID should be in the QVD but not in the database.
