Sending duplicates to a file

In this post we show the process to identify duplicates in a file and then send those duplicates to an output file. This is very useful when you believe that there are large amounts of duplicates in the file you are examining, or when you need to share the output from your analysis with another user.

The steps to perform this are:

The steps shown in the video are:

  1. Import your file

  2. Select the "Analyze" menu

  3. Select the "Duplicates" menu item

  4. Select the fields you want to test

  5. Click on "More"

  6. Select the fields you want to output to the new file (I normally just select all)

  7. Enter an output file name

  8. Click on "OK"

The output file will automatically open. You can now read the duplicate transactions.

Here is a short video of it:



6 views

© 2020 by Survey Design and Analysis Services. 

  • LinkedIn
  • Facebook
  • Twitter
  • YouTube