Find out your File Cabinet database table name (here is FCTABLE) and names of fields that determine your duplicity criteria (here VENDOR_ID and INVOICE_NUMBER)
1. Create a new field in the FC that will indicate non-duplicates (DSTATUS)
2.Create an Autoindex Workflow as following:
External Data Source: Database Connection
Iterated records are in External Data Source - THIS IS IMPORTANT!!!
your FC - no filter (unless fully understand the need of a filter)
Database Connection - Select GUID for your cloud database connection
SQL statement : SELECT DISTINCT VENDOR_ID, INVOICE_NUMBER from FCTABLE
MatchCode on VENDOR_ID and INVOICE_NUMBER
Process First found Document - THIS IS IMPORTANT!!!
Assignment Index Replacement: DSTATUS=NOT DUPLICATE
3. Run the Workflow.
4.Run a Search, observe the result list - all duplicates should have field DSTATUS empty.
5.(Optional and to be used with care only if fully understand) Create a deletion Workflow