ServiceNow Reports - remove duplicate records

[Service Manager]

Hi,

We are working on export of records from Incident metric(Incident_metric) database view.

Records are exporting to an excel sheet via Export set. My question is, how can we remove the duplicate entries from the excel sheet or how could we skip the export of duplicate records.

Thanks

[Steven Parker]

In Excel, if you have full row duplicates, you can highlight the entire sheet and click "Data" tab and "Remove Duplicates" which is in the "Data Tools" section.  It'll tell you how many duplicates it removed as well.

You would likely need to query or filter out records to remove them from an export.  Easy to remove them in Excel though if they are full line duplicates.

[Service Manager]

Thanks for your quick response!

I cannot remove duplicates records manually. The excel file is exported on Mid-server at every half an hour, so I wanted to remove from ServiceNow perspective.

Thanks 

[Jags5]

there will online help to color code duplicate rows in excel. If you want to prevent a duplicate record from being exported,

• Write a query on database view to identify duplicate records.
• Mark the duplicate record as inactive.
• Apply active filter on export set definition.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Service Manager]

Could you please elaborate on identifying duplicate records and marking them inactive. ?