I've searched UX.SE and other resources but not able to find any solid answers on how to merge N multiple records.
Here is the attached screenshot of application which needs to be revamped.
Before you see the screen, pls consider below things:
Who will be using application: User will be Admin, whose job is merge duplicates or non duplicates data quickly and efficiently
Limitatation : There is no limitation on number of merging records. There could be N number of duplicates at a time.
Each records could have 50+ fields.
In just previous screen user is selecting 8 records which he wants to merge and move to next screen, 2 more columns are being added in above screen which creates mess with horizontal scroll. Also there are long fields value like "Gentsesteenweg" or long email ids (firstname.lastname@example.org) which increase col width.
I would like to get rid of this and want to create best user experience to help user to quickly see, edit, merge and leave the screen.
I have gone through Gmail, yahoo and other applications and performed duplicate merge, but they don't fit the bill. Even followed : Design pattern for merging duplicate contacts?. Merge multiple table entries And picked some suggestions but as my problem is different, hence need different solutions
To reduce the clutter in preview screen, purposing below designs with number of duplicates before the merge, so that user can select which records he want to merge.
But there are again a problems like if user wants to see preview (by hitting small down arrow) it will create huge Vscroll. I Assume that should be acceptable.
In merged preview screen, I'm only showing merged records. But the problem is now user can not select any value form either of records. He must have to edit info which is again take good amount of time.
In below image, merged data is shown on the left along with conflicts on the right. I'm curious to know about the alignment of conflicts tables vertically or horizontally. Any thoughts?