Determining which values in field got removed between two dates

[Panv]

hi, I have a list of email subscribers and a time series weekly snapshot date of when those subscribers exist.

Data structure is as such:

Email | Date

Test@test.com | 11/22/2020

Abcd@test.com | 11/22/2020

123@test.com | 11/22/2020

Abcd@test.com | 11/29/2020

In qlik sense load script, every week I want to isolate which users unsubscribed by comparing the email list from 2 dates ago to email list from most recent date.  I need to isolate just these users who lose access so I can do further analysis and join them in some other tables.

Based on given example above, the result should be:

Test@test.com

123@test.com

Since both of these emails existed on 22nd but no longer exist on list in 29th.

How can I go about doing this as the date for both is in one field in the table?

[Vegar]

If you are doing this in the script then you could do this by following these steps. 

Load all email from last date (11/29/2020) 

Noconcatenate Load all emails from the previous date (11/22/2020) where not exsist email in first load.

Drop first load table.