Unique ID Checking in incremental script Qlik Sense

[UserID2626]

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.

[Kushal_Chawda · Accepted solution]

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.