The most common reason for an employee showing up twice in employee listings is that the employee has multiple current appointment records.
In such cases, the system will display a separate row for each appointment. This is expected behaviour, as listings are designed to show each active appointment individually.
📌 Note: If you require a listing or export that returns only one row for each employee, you should use the table Person.Details, avoiding use of Snapshot.
Duplicates show without multiple appointments present
Another reason for a duplicate appearing in a people listing may be that there is a field in the field list that doesn't relate to the person record in a one to one relationship, but instead in a one to many.
For instance, looking at a list of leavers, you might see an entry for each appointment an employee had, even though the appointment field may not be shown/be visible.
You may be able to quickly identify a Field or View from a listing by exporting the data:
Filter the listing to show the duplicate records.
Right click the data in the listing.
Hover over Export Data.
Hover over Export to Excel.
Hover over All Pages.
Click Export Hidden Columns.
Opening this may highlight where you have unique data. However, if this doesn't make it clear, you will need to confirm the View or Table which is causing the query to return more than one row.
Identify if there is a field that relates to a view or table that returns unique information
Within the Admin Tool, click Menus,
Select the relevant Menu Set and navigate to the area on the front end that shows the duplicate.
Double click the Menu Item to explore the Processes, click on the padlock to unlock if necessary.
Select appropriate list.
Expand User Interface.
Within the View area click Change, scroll to the right and take a note of description of this field list .
As a test change to a simple and standard list with as few items as possible, i.e. [name] if this correctly only displays a single entry then the problem is definitely with the listing.
Click OK, then Apply.
Refresh the front end and check to see if the listing reflects the changes and, if only 1 line of data applies, if so this confirms that this is not duplicate data but rather there is a field that contains unique data. Otherwise please raise a case with support.
If you have confirmed that there is a unique filed in the data, you follow the steps from 1 to 5 and now click Edit Selected to manually adjust the listing.
Remove any entries from the problematic Field list, one by one, or rebuild the field list checking to see which field causes the duplicate.