Merge functionality

There's a whole bunch of questions that arise from this...

• how will you decide which attributes from which records will be selected to be in the merged record? Will this be rules-based?
• will the merged record be a new record (with the original records being either hard deleted or soft-deleted - that is, do you need access to the original data for traceability purposes?)
• what is the User Experience you're looking for? Will the User select a "Merge Records" button and when confirmed then the original records disappear from the grid leaving the newly merged Record still visible?
• should there be an "Undo Merge" functionality?

There's a whole bunch of questions that arise from this...

• how will you decide which attributes from which records will be selected to be in the merged record? Will this be rules-based?
• will the merged record be a new record (with the original records being either hard deleted or soft-deleted - that is, do you need access to the original data for traceability purposes?)
• what is the User Experience you're looking for? Will the User select a "Merge Records" button and when confirmed then the original records disappear from the grid leaving the newly merged Record still visible?
• should there be an "Undo Merge" functionality?

The exact requirement is , the user needs to select two or more records and should click on Merge button, so that the result should be for those selected records should be merged into one record.

Whatever the records we have selected, those should not be deleted instead those needs to be merged into one record.

We cant undo the Merge functionality, in UI it should display with the newly merged record instead of two or more selected records.