Hello,
We are trying to select donors living in a certain zip code but it keeps giving us results that include donors who have inactive addresses from this zip code. How can we exclude those inactive addresses in the extraction?
Thank you.
Ludivine
I often add Primary Address Flag IN Yes to specify I only want to use their starred address. If you want multiple addresses to qualify someone I don't think an Address Inactive criterion exists but you should bully someone at your organization (or the network!) to custom create it because then you can add Address Inactive NOT IN Yes.
-- Mike
Thank you, Mike. I will try that!
There's an "EAddress Inactive" criteria in T_KEYWORD that, if you copy it, and then update all instances of "eaddress" to just "address" (vs_eaddress becomes vs_address, etc) it should do the trick.
Although, if someone has both an active and inactive address in that zip code, won't this suppress their record?
Thanks for the exact keyword to copy and update!
Since the only value for Address Inactive would be Y/N it won't matter if the zip codes overlap because the condition is solely on the inactive flag. A statement with "where postal_code = '10001' and address_inactive NOT IN Y" would still pick up a current address in 10001.
Oh, duh, Mindee.