We are importing 60k records that are currently one ITEM record, we are splitting these into CONTACTS. CASES and *ITEMS.Because no contacts existed previously we will get one contact created for every ITEM
Some contacts have a postcode or email address which will show us if they are, for example the same personeg. A Jones (firstname.lastname@example.org)Andy Jones (email@example.com)We need a tool that will identify possible matches, allow us to agree which matches are correct and reject erroneous ones and then update all relevant records with the CONTACT :[RECORD ID] that is to be kept and delete the duplicate contacts. NB we are already working with a QBSP, but we are opening to buying in a third party tool if someone has devloped one.