Constituent Address Query

Laura Marcinkowski
Laura Marcinkowski
Kudos 1 Name Dropper First Anniversary Facilitator 1
in Blackbaud Raiser's Edge NXT®: General Discussions

I'm wanting to pull a query for constituents who have multiple duplicate address' on their profile. Does anyone know how I would set that up? TIA!

Tagged:

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Laura Marcinkowski
    You can use a constituent query and output from the “All Address” section.

    then you have to find dup in excel, taking into consideration that you may not have all address fully standardized. (i.e. you may have 123 Main St for one address and 123 Main Street for another).

    There are some excel formula play you can do here.

    For example: if you output Constituent ID as column A. You can use a formula =COUNTIF(A:A, A2) and filter any rows that has 1, meaning there's only 1 address record. You can also do the same by using conditional formatting to highlight dup and then filter on the non-highlighted to delete

Categories