Skip to main content
Version: Python

How to select distinct values in a table

This guide shows you to how to use the Select Distinct Values feature, which modifies a table to show unique values from a selected column. This produces the same result as the query method select_distinct. A Select Distinct table is often used to trigger filters on other tables in a workspace. See How to filter without writing queries to learn more.

From the options menu of the table you'd like to reduce, choose Select Distinct Values. Pick a column from which to display unique values.


  • Filters previously applied to the table will be reset.
  • You can add additional columns.
  • Delete your selections using the trash icon to the right of its name. Deleting all selection restores the table to its original state.