Hi all,
I'm trying to delete duplicates from _Subscribers but I'm getting some discordance problems on the results. I'm using the following query in order to find email duplicates:
SELECT SubscriberKey,emailaddress, status
FROM _subscribers
WHERE emailaddress IN (
SELECT emailaddress
FROM _subscribers
GROUP BY emailaddress
HAVING COUNT(*)>1
)
Then, I import the results to a list and delete them. The problem is that if I search them through the search panel on All Subscribers it doesn't show me any results (the register was deleted indeed), but if I run the query again, it shows me almost the same results as before, like if it didn’t delete anything. Do I just have to wait before the registers are deleted from an internal table or something like it?
Thnx and good day,
