-
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
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
You’re offline. This is a read only version of the page.
