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

    Deduplicate

    True if it's the first time we see the input value in the data in the specified window size.

    Inputs

    • value - value to deduplicate

    Properties

    • Connection - The storage to use to save state data
    • Window Size - Deduplication window size in minutes

    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

    NOT_EQUAL_TO

    Returns true for instances where the operands are not equal

    Inputs

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

    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

    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