Hi all,
I'm working on a somewhat unique data pull and in cases where a household qualifies under the criteria I have set, I'd like the household to be replaced with just the A1 affiliate of that household (in other words, if the John and Jane Smith Household qualifies, I'd like my results to list John's individual record only). Essentially, I'd like to do the opposite of the "Replace individual constituents with their primary households, if one exists" functionality that List Manager offers. This is something that I am happy to do either in List Manager or in a SQL query, so ideas from either avenue are welcome. Thanks for any insight you can provide!
Lauren
VS_CUSTOMER_WITH_PRIMARY_AFFILIATES probably will give you what you need, and I think could be easily worked into list manager with a manual query, but should mention there's also an affiliates info output element in the cookbook (includes script for a different view with the details of affilates' phones and eaddresses). www.tessituranetwork.com/.../Tessitura.htm