Brian Whitford CBIZ Developer/Analyst

I was able to do this for a recent migration.  I setup the criteria for Autoindex to search then in the match data tab I did a match on an external database.  This database was just the file cabinet database using the following SQL statement:

select count(DOCUMENT_ID) as counts, DOCUMENT_ID
from DWRPSTPA_ACTIVE.dbo.RPS_TPA
group by DOCUMENT_ID
having count(document_id) > 1

In the above SQL statement, DWRPSTPA_ACTIVE.dbo.RPS_TPA is the file cabinet's database and DOCUMENT_ID is actually an ID from another system used during the migration (not the DWDOCID).  It totals up the ID numbers and when the count is > 1 in the assign data tab I assigned the duplicate index a fixed value if yes for all matches