How can I find duplicate values in a specific field?

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

The easiest way to find places where the same value is used in the same field across multiple records is to use a summary report. To do this, click the name of the table you are interested in finding duplicate field values for and select Create a new Report. Within the Report type section, select Summary. Now set the view properties to the following:
- Group Summary By: set this to the field you are interested in identifying duplicate entries for.
- Columns to Display: leave the default value, which should contain "# of <what track>" where the <what track> will be filled in with the noun used to represent the types of items you track in that table.
- Sorting: select the "Custom sorting/grouping" and sort by "# of <what track>". Also select the "from high to low" in the order dropdown, which will ensure that the field values that have multiple records will show up at the top of the list.
- Filtering: leave this set to default, which is to show all of the items you are tracking.

When you "Display" this report, you will be presented with a table that has two columns: the field values in the first column and the number of times that field's value has been entered across all records. At this point you can click on the field values to get the list of all the specific records that have that specific field value.

Tags:

36367 reads

Comments

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * Type the characters you see in this picture.

(verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Knowledge Base