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