Is there a way to create a data extension using a filter which filters against the Profile Attributes in the All Subscribers List.
I know I can create groups filtering the All Subs List and I can create Data Ext filtering other Data Ext but I haven't seen away to create a Data Ext filtering the Profile Attributes in the All Subs list.
SELECT SS.EmailAddress, SS.[Order Submitted Date], SS.[First order for this Contact], SS.[Active PG Member], SS.[LL Kit], SS.[LL Fed], SS.[LL State] FROM _Subscribers SS WHERE SS.Domain = 'YAHOO.COM'