Skip to main content

icase not in

The icase not in match filter returns rows that do not contain a match of one or more specified values, regardless of the capitalization of the values.

Syntax#

columnName icase not in valueList
  • columnName - the column the filter will search for non-matching values.
  • valueList - the set of values to remove. This supports:
    • a comma-separated list of values: A icase not in X, Y, Z. The filter will return true for all rows where the value in column A is not equal to X, Y, and Z.
    • a java array: A icase not in X. The filter will return true for all rows where A is not equal to every element of the java array X.
    • a java.util.Collection: A icase not in X. The filter will return true for all rows where A is not equal to every element of the collection X.
  • all other types: A icase not in X. The filter will return true for all rows where A is not equal to X.

Examples#

The following example returns rows where Color is not in the comma-separated list of values. Capitalization is ignored.

from deephaven.TableTools import newTable, stringCol, intColfrom 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.where("Color icase not in `Blue`, `Orange`")

The following example returns rows where Color is not blue or Letter is not a. Capitalization is ignored.

from deephaven.TableTools import newTable, stringCol, intColfrom 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 icase not in `Blue`", "Letter icase not in `a`")

The following example returns rows where Color is not in a collection of values.

from deephaven.TableTools import newTable, stringCol, intColfrom deephaven.conversion_utils import NULL_INT
myList = ["Pink", "purple", "BLUE"]
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.where("Color icase not in myList")

Related documentation#