Comparing unique ID's in incremental script Qlik sense

[UserID2626]

how to compare unique id's in qvd with DB. 

[jwjackso]

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);

[UserID2626]

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.

[jwjackso · Accepted solution]

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.