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?
