• RE: How to setup an autoindex to mark duplicate documents.

    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
    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