Duplicates in Query when Outputting WealthPoint Rating

When including Target Analytics WealthPoint Rating in the Output of a Constituent Query, constituents appear more than once even when only one rating is found on the Constituent Record.
We are currently evaluating this issue and will update this article when we have more information. 

Steps to Duplicate

Log into The Raiser's Edge
Create a New Constituent Query
Enter your Query Criteria
Go to the Output Tab
Include Target Analytics WealthPoint Rating in your Output
Run the Query
Constituent Appears 11  times
Go to Tools>Query Options
Suppress Duplicates
Constituent Still appears 11 times
Remove Target Analytics WealthPoint Rating from Output
Run the Query again
The Constituent appears 1 time


 SQL Server 2008 R2
 Raiser's Edge

Was this article helpful?