Skip to main content

whereOneOf

The whereOneOf method returns a table containing rows from the source table, where the rows match at least one filter. Each filter clause is evaluated independently.

Syntax#

table.whereOneOf(filterCriteria...)

Parameters#

ParameterTypeDescription
filterCriteriaString...

A collection of formulas for filtering.

Filters can be:

  • A match filter.
  • A conditional filter.

Returns#

A new table containing rows from the source table, where the rows match at least one filter.

Examples#

from deephaven.TableTools import newTable, stringCol, intCol, doubleColfrom deephaven.conversion_utils import NULL_INT
source = newTable(    stringCol("Letter", "A", "C", "F", "B", "E", "D", "A"),    intCol("Number", NULL_INT, 2, 1, NULL_INT, 4, 5, 3),    stringCol("Color", "red", "blue", "orange", "purple", "yellow", "pink", "blue"),    intCol("Code", 12, 13, 11, NULL_INT, 16, 14, NULL_INT),)
result = source.whereOneOf("Color = `blue`", "Number > 2")

Related documentation#