Home > Tools > Duplicates

Duplicates

Location: ReportsDNA toolbar | Tools | Duplicates

The Duplicates tool can be used to remove, highlight, find, flag and count duplicates (see figure 1).
This tool will make a COPY of your worksheet and display the results on the COPY.
Before you select the duplicate tool you must select the headers and data to be processed (see figure 2).

Figure 1: Duplicate Tools


Figure 2: Selected headers and data


Next click the duplicate tool desired and click the go button. The duplicate tools form will appear (see figure 3).

Figure 3: Duplicate Tools form


#
Section Description
1 Duplicate Tool
Dropdown list of available duplicate tools.
Defaults to tool selected from the Tool chooser.
2 Fields for Unique ID
List of fields available in the data set.
Check the fields to define what uniquely identifies a record.
In this example, the First Name combined with the Last Name define a unique record.
3 Case Sensitive option
Toggle to indicate if the Unique ID is case sensitive
4 Duplicate Flag Options
These options can be used to flag duplicates. The 3 options are described below and
active based on the tool chosen in section 1.
No - duplicates are not flagged. This option is typical when duplicates are removed.
Count - a column is added to the data and is populated with the number of times the record occurs in the data.
Flag - a column is added to the data and is populated based on the Flag Values (see section 5).
Duplicates will have the Duplicate label (default value is True).
Non Duplicates will have the Not A Duplicate label (default value is False)
5 Flag Values
Defines the labels that will be applied to duplicates and non duplicates.
Duplicates will have the Duplicate label (default value is True).
Non Duplicates will have the Not A Duplicate label (default value is False)
6 Submit/Cancel buttons
Submit executes the currently selected tool.
Cancel closes the form without executing the tool.




Example settings and results

Data
The data used in these examples are from Figure 2.

Results
Duplicate Flag Option Form Results
 No

1-check the index columns
2-choose No
3-click the Submit button

   
Count

(check the index columns)
1-choose Count
2-Enter the Column Name

Click Submit




Flag


1-check the index columns



2-choose Flag

3-Enter the Column Name



4-Enter the labels which

identify a Duplicate and

a Non-Duplicate





Click Submit


See also

Filters