This interface concept demonstrates a method for merging duplicate records when importing data from a file or another data system. In this example, a user imported an Excel file of employee information. There are multiple suspected duplicate employees. Duplicates without differences can be merged at the click of a button or en masse. Those with differences—maybe "Bob" versus "Robert" or a transposed number in a employee number—will require walking the user through the merge process, which will be discussed later. The result is a process that helps the user feel comfortable the resulting data is clean by providing feedback and transparency through the process. Despite being a manual process, the interface gives a clear path and empowers the user to quickly make informed decisions. Typical merge operations are destructive, but this method [SVG](through hypothetical database) a new version of the employee record linked to the previous two, so that merging/separating can be non-destructive. A user can abandon or undo work as needed through the workflow.
This is an interactive prototype to demonstrate interactions. This demo does not save information between pages, either client-side or in a database. It is purely to provide an overview of a interface solution to common data system workflow.