Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Facets and filters

Facets show what is in a column and narrow the grid to the rows you pick. Every operation and every export then applies to those rows only, as in OpenRefine. Open them from a column's menu under Filter. They appear in the Facets tab of the side panel; + Facet on a column… at the bottom of the panel, or F on the column you last used, adds one. Each facet that filters shows as a chip in the bar above the grid: its × clears that filter, Clear all clears every one, and the bar shows how many rows match.

Use the arrow in a facet's header to collapse its controls. Its filter stays active, and expanding it restores the same choices, sort order and inputs. Removing a different facet does not move that collapsed state to another one.

Numeric and timeline facets also have Reset facet in the header. It restores the full range and includes every value kind again, keeping the facet and its expression. It does not add a history step.

Kinds

  • Text facet: each distinct value with its row count, by count or by name. Click choices to include them, use invert to exclude them instead, and use the pencil to change a value in every row. As in OpenRefine, a facet with more than 2,000 choices lists none; Show all raises the limit, which you can also set in Preferences.
  • Numeric facet: drag across the histogram to select a range, or drag either boundary handle. The from / to boxes let you enter exact values; switches include non-numeric, blank and error cells.
  • Timeline facet: the same for dates, with dates in the boxes. Both histograms have focusable boundary handles: arrow keys adjust a boundary, Page Up / Page Down make larger changes, and Home / End move to the available limits. Escape or a cancelled pointer gesture leaves the previous range in place.
  • Text filter: keeps the rows whose cell contains the text you type.
  • Custom text facet… / Custom numeric facet…: a facet over a GREL expression, such as value.length() or cells["city"].value + ", " + value.
  • Customized facets: ready-made expressions for words, duplicates, text length, Unicode character codes, blank cells, errors, stars and flags. Logarithmic numeric and text-length facets help inspect wide ranges; the 1-bounded numeric log facet clamps numbers below 1 before taking the logarithm. Facet by null and Facet by empty string distinguish missing values from empty text.
  • Reconciliation facets: judgment, best candidate's score, type match, name match, edit distance, word similarity, types, judgment action and history entry. See Reconciliation.

Numeric ranges include the lower boundary and exclude the upper one; timeline ranges include both. Dragging updates the filter when you release the pointer. Empty, degenerate or unrepresentably wide domains do not offer draggable handles; the value-kind switches and available input boxes still work.

Rows and records

Switch between Rows and Records at the right of the bar above the grid. In records mode, a row with a value in the first column starts a record, and the following rows with that cell blank belong to it. Facets then count and filter whole records, as in OpenRefine.

Speed

Facets count each distinct value once, not each row. A text facet over a million rows takes about 10 ms.