We have an email validation process that checks a list ID for an email in order to validate if that person has already signed up. Currently the only way I know to automatically populate that list is:
Query to DE > Data Extract of DE > File Export > File import to list.
The problem I have now is the file import to the list can't be set to overwrite, the only option is add, update or add/update. I need this process to overwrite the list daily in order to have accurate daily records to validate. Records can change daily from active to inactive.
Two questions: Is there a better process I can use that will overwrite the list? Is there a script I can run that will clear the DE before the list import?