Skip to main content
2 of 2
added tag, removed unnecessary characters

Filtering out entries from one data extension to another

Currently I have a subscription form that is sending all new subscriptions to one data extension. One of the options they select on the subscription form is "Customer Type." I have four different customer types that need to be filtered into four corresponding data extensions.

I created four data filter activities (ex: If Customer type is equal to "Customer Type 1").

I know that I need to use Automation studio for this and a SQL script. I'm looking for some resources on how I build this workflow in Automation studio to ensure all entries are taken out of the first data extension and put in the data extension with the corresponding customer type.