identify duplicate records via report

[SinghaiPrachi]

Hi,

I have many feeds running for the same application but I am facing records duplication issue. Although I have updated the key field for the feeds so it stopped duplication. But for cleaning of the duplicate records is there any report we can create to identify and delete the duplicate records in a bulk.

Thanks,

Prachi Jain

[DavidPetty]

@SinghaiPrachi Archer has no way to identify duplicate records via a report.  But you can create a report and include the tracking id field of all the records and in Excel identify the duplicate records, delete the records (rows) to keep, save as CSV and use this tool to bulk delete, Archer Bulk Record Deleter - a PowerShell script to delete content records using a CSV file and API - Archer Community - 566002 (archerirm.community)

[SinghaiPrachi]

Hi @DavidPetty 

Excel is getting hang up as record count is way too many in the application. That's why I am looking for more feasible solution to identify duplicates.

Thanks,

Prachi Jain

[DavidPetty · Accepted solution]

Excel is the only way I know of.  You'd have to split the report up into chunks in order to get it to work with Excel.  Save the report as CSV and use notepad or notepad++ to split the file or use a PowerShell script like this one to split the file, https://stackoverflow.com/a/14755303