Spot and delete the duplicates
It could sometimes be useful to spot the duplicates, and even delete them. These duplicates may be present in several cases for example :
- A person has answered twice to the questionnaire (once by post and once online).
- A fusion with another data base which has been realised and duplicates appear.
When we have a file of targeting clients (en vue d’un emailing),We could have the same mail adress several times for different people (a husband and a wife could have a common mail adress). We have then two contacts (Mister and Madam) and we wish to send just once per home. In this case, we should spot the duplicates on the mail adress and delete one of the two contacts (mister or madam).
In all cases, the duplicates are spotted by the biais of one or many variables of identification of the observation (login, key, mail adress, client code, …).
- In the tabt Data, click on the button Remove duplicates.
You reach the following dialog box. You have the choice to spot only the duplicates or to delete them from your data set.