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
I'm sure it's possible in SQL but my dumdum way would be to replace individuals with household (if exists) AND add all primary affiliates, then add an output element of a1/a2 indicator and filter by a1. I think that should work?
just tinkering around, you might need to experiment with the Primary Affiliate filter as well.
That's a good idea! I'm off to do some experimenting with that. Thanks, Eric!