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
Originally posted on July 31, 2024 in the Archer Community.
Comments
3 comments
@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)
Originally posted on July 31, 2024.
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
Originally posted on July 31, 2024.
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
Originally posted on July 31, 2024.
Please sign in to leave a comment.