Exporting optional addresses

Kevin, 

I am running in to this issue - i need an output that pulls all available options of our address types, NOT just the primary address.  
I don't see this option in the output recipe book - and we do not have IT support at our org, and cannot afford consulting - is there an output set recipe that you have for this, OR is there another way for me to get this info about my constituents via list/extraction or output set that I'm just not aware of? 

Thank you! 

Hi Kelly! Kevin asked me to reply on his behalf. I suggest you implement the Emails by Type recipe. If you use this element without the filter applied, it will return all active email addresses for a constituent. 

Thanks Michael! I was looking for mailing addresses- will this idea used for the emails work for trying to build the output for address types too?

Oh I'm sorry, I read too fast! Postal addresses are really similar to emails, just a few more fields. 

Add a row to TR_QUERY_ELEMENT_GROUP with a Description of "Address – Multiple Output" (or however you'd like to label it), a Data From to VS_ADDRESS, a Data Where of !.inactive <> 'Y' and a Category of Address Information.

Then add 5 rows to TR_QUERY_ELEMENT (for street 1, street 2, city, state, and postal code):

1. Street 1: 
   1. Description: Street 1
   2. Group Id: Address – Multiple Output 
   3. Data Select: !.street1
2. Street 2: 
   1. Description: Street 2
   2. Group Id: Address – Multiple Output 
   3. Data Select: !.street2
3. City:  
   1. Description: City
   2. Group Id: Address – Multiple Output 
   3. Data Select: !.city
4. State: 
   1. Description: State
   2. Group Id: Address – Multiple Output 
   3. Data Select: !.state
5. Postal Code:
   1. Description: Postal Code
   2. Group Id: Address – Multiple Output 
   3. Data Select: !.postal_code

Thanks again Michael Flaherty-Wilcox

two questions - do i need to create anything under: TR_QUERY_ELEMENT_PARAMETER? 
Also with the TR_QUERY_ELEMENT - should i select single row? 

is there a way to have it note what "type" the address is pulling from or can I create an output filter for that? if so - what's a suggestion on creating an output filter? 

Thank you again for your help! 

Do not mark any of the rows as "single row" for this situation.

Yes, you can make an output filter for address type. Add a row to TR_QUERY_ELEMENT_PARAMETER as follows: 

Description: Address Type
Group Id: Address – Multiple Output
Filter Element: address_type
Data Type: String
Ref Tbl: VRS_ADDRESS_TYPE
Ref Idcol: id
Ref Desccol: description
Ref Sort: description

Outputting the name of the address type along with this data requires a slightly different query. Hopefully the filter is what you need, but let me know.

this is absolutely perfect!  thank you so much for your help Michael Flaherty-Wilcox!  It is much appreciated! 

this is absolutely perfect!  thank you so much for your help Michael Flaherty-Wilcox!  It is much appreciated!