Skip to content
English - United States
  • There are no suggestions because the search field is empty.

Deduplicating a Multi-Column Dataset of Content in Excel

To export your Content follow these steps:

1. Navigate to the RocketDocs Content Module and filter down to the subset of content that you would like to run deduplication on.

2. Use the field selector to select the ID column plus the fields you would like to include in your deduplication effort.

d950c837-93ca-4afe-b693-b169a81540a7
 

3. Export selected content into Excel.

eeef1256-e97e-43b5-99f6-60731a0e49a6

How to identify the duplicates with Excel:

1. Review and identify the items from the duplicated that you would like to delete. If there are two duplicates it will mean deleting one of the rows/records. If there are more than two you may have to delete several rows/columns.

2. Highlight the rows that you identified for deletion using a different color. Then filter the ID column by that color.

3. Select all of the content IDs that you have identified for archiving or deletion in the Excel spreadsheet, right click and select copy.

 

Identify Duplicate Content records in RocketDocs

1. Select all of the content IDs that you have identified for archiving or deletion in the Excel spreadsheet, right click and select copy

2. Paste the IDs into the search screen, select ID in the drop down and click enter in the search bar to perform the search.

9933bcc3-059c-49a1-94c6-4b994f7b64e5
 

3. Select the checkboxes next to the resulting records.

0d65428d-6362-417a-b65d-6679b47f1204
 

4. Select Delete Content or Archive from the drop-down Menu.

1dfbcc1c-d58d-4b0e-8ae9-79cb3d469036

⚠️IMPORTANT:⚠️

Archived records can be restored by the content administrator. Deleted records cannot be restored.