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.

Any insight would be super helpful.

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.