How Do You Query/Export Data Points For Events Over Multiple Years

Options
Michael Bober
Michael Bober ✭
Seventh Anniversary Photogenic First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion
Hello Everyone,


I sure could use some guidance on this one. I can't figure out how to export my query in a way which lists yearly events in separate columns for people who attended who are both constituents and not constituents in Raiser's Edge. I had to do this manually while also deduping manually as well. It became extremely tedious since there are over a 1,000 participants in the CSV file. Does anyone have any advice on this? Thanks!


  2017 2018 2019 Constituent ID Participant Title 1 Participant First Name Participant Last Name
2016
Tagged:

Comments

  • Mark Guncheon 2
    Mark Guncheon 2 ✭
    Tenth Anniversary Facilitator 2 Name Dropper Photogenic
    Can you show us what you do get from your current export and what you manually convert to? (Use fake names.)

    And what kind of export are you using?

Categories