I have a data extension in which I have 2 columns:
The CategoryType column gets data like this:
Category A, Category B, Category C
So for email firstname.lastname@example.org, I can get this - Category A, Category B, Category C
For another email, I can get this - Category D, Category E, Category A
As you can see, I can get different categories for different customers and the data is inserted in my data extension on daily basis.
Hence, category type can easily multiply.
I have to send emails based on audience for each category. So Email 1 to CategoryType A, Email 2 to CategoryType B and so on...
This requires me to create manual data filter for each category and there should be hundreds of different category types. I also won't know if any daily import includes new category type or not.
Is there any way to automate the process of filter creation based on all categories available in the data? OR is there any way to send emails based on specific category only without creating filters?