Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.