Constituent Address Query

Options
Laura Marcinkowski
Laura Marcinkowski ✭
Facilitator 1 Name Dropper First Anniversary
in Blackbaud Raiser's Edge NXT®: General Discussion

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 ✭✭✭✭✭
    Ninth Anniversary Facilitator 4 Name Dropper Photogenic

    @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