Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Partner - Creator III
Partner - Creator III

Comparing unique ID's in incremental script Qlik sense

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

 

 

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

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.

View solution in original post

3 Replies
jwjackso
Specialist III
Specialist III

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
Partner - Creator III
Partner - Creator III
Author

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
Specialist III
Specialist III

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.