PSFS IQ - Results: How to remove duplicate records from your query results

How to remove duplicate records from your query results

This topic shows you how to add a "unique" rule to your query. This rule specifies that no two records can have the same value. Use this procedure to remove duplicate records from your query results.


To remove duplicate records from your results:

  1. Build the query the way you typically do by choosing columns from the Column Picker and specifying conditions.
  2. At the top of the Query Results panel, select the Unique Records Only checkbox.
    • This checkbox is located at the top of the Query Results panel, as shown in the following illustration:

  1. Click  to run the query.
    • The Query Results panel displays unique records only.

Related Articles

How to rename a column heading in your query results

How to reorder the columns in your query results

How to sort a column's data

How to use the result of a query in another query

How to find all results that do not match a condition

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.