Hello all,
Unfortunately, we let our de-duplication process go for a while and now have a large list to tackle. For planning reasons I'd like to know how many potential duplicates there are. I can see the list on the Merge Potential Duplicates screen but I'm wondering if I can export that list somehow or if there exists a report that will give me the info.
Thanks in advance,
Ellen
If you have access to the database then you can just run this query to get a count.
select COUNT(customer_no) from T_POTENTIAL_DUPS
Note: that gives you rows in the table, you'd want "distinct customer_no" for a proper count of the records affected, and "district criteria" for a could of the actual merges.
Thank you, Gawain.
I would also add a WHERE clause of WHERE status = 'P' or the results will include records you've already decided upon (keep or discard).
Technically, you should halve the result number because the table contains a row for both the original as well as the potential duplicate accounts.
You then select to either keep 'K' or discard 'D' and those get updated in the status and keep_cust columns.
customer_no status keep_cust
1234 K NULL
4321 D 1234
Thanks, Neil.
The status codes that I see in that table are F,M or P
For reference, F = failed, M = merged, P = potential (has not been scheduled)
You'll see K and D when a pair has been scheduled for merge, but the merge process has not yet been run.