Qlik Community

New to Qlik Sense

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

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Creator III
Creator III

Unique ID Checking in incremental script Qlik Sense

Hi,

I wrote incremental script based on unique Id's and storing them in day wise QVD.

if any records been inserted or updated based on load date it will run the incremental script for insert, update & delete.

Now I am facing in finding deleting Unique Id's alone. 

Consider having QVD from Aug 1 2020 to Aug 26, 2020. If any records been deleted in 15 Aug and there is no update or insert for Aug 15 then i can't run incremental script based on load_date > max(load_date).

My Qvd's are in day wise so how to get that deleted unique ID.

No flag been set fr deleted records in DB.

 

 

 

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

Seems to be complicated due to daywise store of QVD.

I think you need to load all the previous day QVDs then you can check for any deleted records using not exists (key)  and  create single QVD(all days) which you can use it to create daywise QVDs again based on load date in QVD.

View solution in original post

1 Reply
Kushal_Chawda

Seems to be complicated due to daywise store of QVD.

I think you need to load all the previous day QVDs then you can check for any deleted records using not exists (key)  and  create single QVD(all days) which you can use it to create daywise QVDs again based on load date in QVD.