Duplicate data can cause a number of issues in your Workbooks database: inaccurate reporting, lower work efficiency, wasted resources, etc. Workbooks has two methods of cleaning your data and removing duplicate records:

• Workbooks Merge
• Workbooks DQ

Workbooks Merge

Workbooks' own Merge functionality comes as standard with any Workbooks license, and is designed to help you remove duplicate records in batches of up to 5 records at a time. As such, this is best suited for databases that have a smaller number of records, or are confident that their data is of a high quality. You can find out more about the Workbooks Merge functionality here.

Workbooks DQ

Workbooks also offers Workbooks DQ, which is an optional extension that can be purchased alongside your Workbooks license (for more information about pricing, see our Pricing page). Workbooks DQ provides a much more in-depth way of managing duplicate data by making use of matching rules and configuration done within the Workbooks DQ window. One key feature of Workbooks DQ is that it can de-dupe up to 1000 records at a time, making it ideal for databases with large amounts of incoming data that may need verifying. More information on this can be found here.