Why exports show each person multiple times

Modified on Fri, 24 Apr at 3:27 PM

Oho exports one row per check or accreditation, so a person with multiple checks (for example a WWCC and an NDIS clearance) appears on multiple rows.

There's no way to deduplicate this within Oho before export. To deduplicate after export:

  • Excel: Select all data, Data tab, Remove Duplicates, select only the person_id or full_name column. Excel keeps the first row for each person and removes the rest
  • Google Sheets: Data > Data cleanup > Remove duplicates, select only person_id or full_name

Caveat: This removes rows for secondary accreditations. You'll lose visibility of additional credentials in that export. Confirm this is OK before proceeding.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article