Remove Duplicate Records
This tool will find all records which contain duplicated data. Comparison
is made according to columns selected from the list. You can select one
or more columns that must have unique values.
If, for example, you have a table as follows:
|
First name |
Last name |
E-mail |
|
Joe |
Smith |
Joe@somedomain.com |
|
Joe |
Oven |
Joe@somedomain2.com |
|
Joe |
Smith |
Joe@somedomain.com |
If you select Last name or E-mail column, after processing you will
get the following results:
|
First name |
Last name |
E-mail |
|
Joe |
Oven |
Joe@somedomain2.com |
|
Joe |
Smith |
Joe@somedomain.com |
If you select First name column alone, or in combination with any other
column after processing, the results will be:
| First name |
Last name |
E-mail |
| Joe |
Smith |
Joe@somedomain.com |
Connection
Sets the database connection properties. This option allows you to choose
the name of the connection from the drop-down list.
Table name
Sets the name of the table.
Column name
Select one or more columns that must have unique values.
Action
Remove
Removes all duplicate
values from the table.
Select
Selects all duplicate
values and does not modify the records.
Create Table
The program
will create the new table with unique values.
Result table name
The program will create the new table with
unique values.
Related Topics:
Advanced settings
Schedule package
for later execution
Scheduling options
Repair E-mail Addresses
Search and Replace
Compare Tables
Filter Records
Filter Through Text File
Remove Duplicate Recipients
Execute SQL Query
| 
