Datamartist lets you find and map duplicate rows
Duplicate rows can cause all sorts of problems with your data analysis. Its hard to properly segment your customers by size when the sales data is spread between multiple duplicates, hiding their true purchase volume.
- FIND the duplicates
- PICK a master record
- MAP the duplicates to the master record just once
Once this is done, all the data coming in will map to the master record. But the original data is not modified in any way, and if required it is possible to track which duplicate row provided the given data, since although the results will be mapped to the correct vendor, the column that holds the previous code or key can be maintained in the table.