... search    filters  - header filters  - side filters    preview    Column chooser    Context Menu    Export


Filter or Search

The Table Editor has powerful options to find and filter data.


The main filtering options are:

  1. Search  (1)- Searches data in all columns
  2. Column Filters (2) - Filter specific columns based on data existing in the columns
  3. Filter Row (2) - Free text search for each column
  4. Table Filters (3) - Column filters for popular columns, chosen at design time.




Search

Search allows you to search for a specific term in all columns. Click the Search box to start searching and enter the search term. When searching for multiple words, you can use quotes to search for them together.



Note that searching data sets with millions of rows and many columns can be slow. You can use Column Filters and Auto Filter Row for a faster search.


Column Filters

Hover over a column header and click the Funnel icon to open a Column Filter. The filter shows all values currently in the data and allows you to quickly filter to specific values. Note that numeric and date/time columns allow you to filter based on ranges.


Filter Row

Right-clicking on a column header and selecting Filter Row displays filtering options per column.



In the Filter Row you can enter search term specific for each column. By default, the search term can be anywhere in the field.






Table Filters

You can specifically configure that are often filtered in the Table Designer. When there are columns with a defined filter, a Filters panel is displayed on the right.

When a value is selected, the data gets filtered in the Table Editor