I have located bounce subscribers by using data views, this gives me a subscriber key but not their email address.
I now want to remove these subscribers from Marketing Cloud and it appears the only way to do this is to add these subscribers to a list and then delete the list while checking delete subscribers from the application. In order to upload a list an email address is required.
Now I'm trying to write a query to extract the email address from all subscribers for these subscriber keys
SELECT * FROM _Subscribers WHERE Subscriberkey = '003i00000024jklrj3' /* these are fake keys*/ AND Subscriberkey = '003i000000rfjkdhsfdf'
Above works but when I try to pull only email address it is not working and I want to do this so when I make the destination data extension I only have to create 2 fields.
The below does not work.
SELECT [Email Address] FROM _Subscribers WHERE Subscriberkey = '003i00000024jklrj3' /* these are fake keys */ AND Subscriberkey = '003i000000rfjkdhsfdf'
First why won't my code above work?
Second, I am going to have to add at least 1,000 lines of code to pull 1,000 subscribers at a time. Is there an easier way to do this?
Thanks for your suggestions