Search results

    Edit on GitHub

    AND

    Returns true if all operands are true

    inputs result
    false, false false
    false, true false
    true, false false
    true, true true

    CONTAINS

    Returns true for instances where the left operand contains the right operand

    Inputs

    • haystack
    • needle
    haystack needle result
    "abcde" "a" true
    "abcde" "f" false

    EQUAL_TO

    Returns true for instances where the operands are equal

    Inputs

    • first
    • second
    first second result
    "a" "a" true
    "a" "b" false
    0 0 true
    1 0 false
    0 1 false

    EXISTS

    Opt in all the rows that contains the specified field

    input result
    "a" true
    false

    GREATER_THAN

    Returns true for instances where the left operand is greater than the right operand

    Inputs

    • first
    • second
    first second result
    0 0 false
    1 0 true
    0 1 false

    GREATER_THAN_OR_EQUAL_TO

    Returns true for instances where the left operand is greater than or equal to the right operand

    Inputs

    • first
    • second
    first second result
    0 0 true
    1 0 true
    0 1 false

    IN_SET

    Returns true for instance where the value is contained in the given set

    Properties

    • Set - Values separated by line breaks
    value Set result
    "a" "a
    b"
    true
    "c" "a
    b"
    false

    LESS_THAN

    Returns true for instances where the left operand is less than the right operand

    Inputs

    • first
    • second
    first second result
    0 0 false
    1 0 false
    0 1 true

    LESS_THAN_OR_EQUAL_TO

    Returns true for instances where the left operand is less than or equal to the right operand

    Inputs

    • first
    • second
    first second result
    0 0 true
    1 0 false
    0 1 true

    NOT

    Returns true if the value is false

    input result
    true false
    false true

    NUMBER_DEDUP

    Outputs the input value only if it's the first time we see that value in the current minute. Use DISTINCT if you want to DEDUP in the context of an array of items.

    Inputs

    • value - value to deduplicate
    value result
    5.0, 6.4, 5.0, 5.0, 6.0 5.0, 6.4, 6.0

    OR

    Returns true if at least one of the operands is true

    inputs result
    false, false false
    false, true true
    true, false true
    true, true true

    RANDOM

    Returns true for a percentage of items equal to the input

    Inputs

    • percent - percent of items to keep
    percent result
    0.0 false
    0.22 true
    0.22 true
    0.22 false
    1.0 true

    STRING_DEDUP

    Outputs the input value only if it's the first time we see that value in the current minute. Use DISTINCT if you want to DEDUP in the context of an array of items.

    Inputs

    • value - value to deduplicate
    value result
    "foo", "bar", "foo" "foo", "bar"

    XOR

    Returns true if both operands are not equal

    Inputs

    • left
    • right
    left right result
    false false false
    false true true
    true false true
    true true false