Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Comparing unique ID's in incremental script Qlik sense

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

 

 

1 Solution

Accepted Solutions
Specialist II
Specialist II

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

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

 

Creator II
Creator II

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.

Specialist II
Specialist II

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