Filter

Key Features

• Column-based filtering – Apply conditions on specific columns by index.
• Comparison modes – Compare a column against either:
  • a literal value (e.g. “Column 2 > 100”)
  • or another column in the same row (e.g. “Column 1 equals Column 3”)
• Supported operators – Equals, Not Equals, Contains, Greater Than (>), Less Than (<), Greater Than or Equal (≥), Less Than or Equal (≤), and Matches Regex.
• Data-type awareness – Automatically detects numbers and dates to compare them correctly. (e.g., “01/01/2024 < 01/02/2024” works as expected).
• Logical combinations – Combine multiple conditions using AND or OR. For example: “Column 0 contains ‘NY’ AND Column 2 ≥ 500”.
• Row range selection – Apply filters only to a subset of rows by specifying a start and end row index.
• Regex support – Use regular expressions for advanced matching (e.g., filter emails with/@gmail\.com$/).

How to Use

1. Open the Filter dialog.
2. Choose a column index to filter on.
3. Select an operator (Equals, Contains, >, Regex, etc.).
4. Pick a target type:
   • Value: Enter a literal value (e.g., 100).
   • Column: Compare against another column’s value in the same row.
5. Set an optional row range (start and end row indices).
6. Add more conditions if needed, combining them with AND / OR.
7. Click Apply to filter the grid. Rows that do not match are removed from the current view.

Example

Suppose you have a sales dataset:

Region | Sales | Target
-------|-------|-------
NY     | 200   | 150
CA     | 100   | 200
TX     | 300   | 250

Filter conditions:

• Column 1 (Sales) > Column 2 (Target)
• Logic: AND

Result:

Region | Sales | Target
-------|-------|-------
NY     | 200   | 150
TX     | 300   | 250