Jump to content

Determine what parent items were deduped in eCapture.


Guest Daniel Hahnke

Recommended Posts

Guest Daniel Hahnke

- Export the deduplication detail report and the discovery detail report

-Filter the discovery detail report and removed the Item ID's for children docs

-Copy the Item ID's for parent docs into a new spreadsheet under column A

-Copy the Item ID's from the dedupe report to the spreadsheet under column B

-Use conditional formatting to highlight items that are duplicates:

-->Select column A (make sure only column a and the cells beneath are highlighted) > select Conditional formatting > New rule > Use a formula to determine which cells to format > Place the following into the text box (do not copy the quotes): "countif=($B:$B, $A1)" > select "format" > select the Fill tab > Select a lighter color to fill the cell with (make sure you can still read the text) > click OK > Click OK.

 

The highlighted cells are parent items that have been de-duped.

Select Column A > select Sort & Filter > click Filter > select the filter carrot on the top cell > select Filter By Color and select "No Fill" > select all the cells that are not highlighted and delete the cells > select the filter carrot > select Filter By Color and select the color you chose to highlight duplicates with > you should now have your document count based on the number of rows in the spreadsheet.

 

Link to comment
Share on other sites

Guest Daniel Hahnke

- Export the deduplication detail report and the discovery detail report

-Filter the discovery detail report and removed the Item ID's for children docs

-Copy the Item ID's for parent docs into a new spreadsheet under column A

-Copy the Item ID's from the dedupe report to the spreadsheet under column B

-Use conditional formatting to highlight items that are duplicates:

-->Select column A (make sure only column a and the cells beneath are highlighted) > select Conditional formatting > New rule > Use a formula to determine which cells to format > Place the following into the text box (do not copy the quotes): "countif=($B:$B, $A1)" > select "format" > select the Fill tab > Select a lighter color to fill the cell with (make sure you can still read the text) > click OK > Click OK.

 

The highlighted cells are parent items that have been de-duped.

Select Column A > select Sort & Filter > click Filter > select the filter carrot on the top cell > select Filter By Color and select "No Fill" > select all the cells that are not highlighted and delete the cells > select the filter carrot > select Filter By Color and select the color you chose to highlight duplicates with > you should now have your document count based on the number of rows in the spreadsheet.

 

Link to comment
Share on other sites

  • 2 weeks later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...