I noticed unlike Standard Data Extensions, email addresses from Filtered Data Extensions are not automatically updated to All Subscribers.
Does anyone know how to make it an automatic process or how can I write a simple query to add these email addresses from my Filtered Data Extensions to the All Subscribers List?
What I am trying to do is to update any new email addresses from a filtered data extension to the All Subscribers List. Hence the columns that I am interested in are: "Email_Address__c" from "FilteredDE" as well as "SubscriberKey" and "EmailAddress" from "_subscribers".
p.s. Sorry I am quite new to SQL Query, so I will need some help to start off with the query script.
Thanks in advanced! :)