#5 How can I store data with duplicated ID numbers? – OrgVue Portal

The issue under analysis here is how to handle non-unique IDs

This is one of a series of articles on solving common data issues derived from in-house experience of Consulting projects using OrgVue

	5 Common Reasons for Duplicate IDs	Resolution
1	True duplication of rows	Check that each property is identical and delete duplicates.
2	One position filled by multiple people	Link a position hierarchy to a people dataset by FTE (assuming a job share situation or similar).
3	One position/person sits in multiple departments or business areas	Make use of multiple reporting line functionality and/or comma separate the non-matching values
4	Vacancies/new positions have blank or common IDs	Create a standard system for these IDs e.g. “New-<row # in source >” (NB. track which IDs have been used by which tranches of positions)
5	Changes over time require cloning of roles	Concatenate ID with start date of each row

Steps to resolve non-unique IDs

Check data quality	Use the Data Types & Patterns Dashboard in OrgVue to identify the number of duplicates.
Filter to duplicates	Filter the data to only the nodes with ‘Yes’ for the metadata property ‘Is Duplicate’
Identify root cause(s)	Inspect the duplicates and identify the root cause and resolution from the list above
Resolve	Manipulate and cleanse the duplicate IDs: Excel Alteryx OrgVue
Upload working data	Re-upload the data to OrgVue in the amended format

If you have any additional queries arising from the above, please select the Submit A Request link from the top right of this screen to contact OrgVue Support

This article was authored by Ben Marshall from the OrgVue Consulting team

Related articles