Filter functions
This page goes over the filter functions in Upsolver.
AND
AND
Returns true
if all operands are true.
inputs | result |
|
|
|
|
|
|
|
|
BETWEEN
BETWEEN
Checks if a value is between two values.
Inputs
value
lowerBound
upperBound
CONTAINS
CONTAINS
Returns true
for instances where the left operand contains the right operand.
Inputs
haystack
needle
haystack | needle | result |
|
|
|
|
|
|
EQUAL_TO
EQUAL_TO
Returns true for instances where the operands are equal.
operand 1 | operand 2 | result |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXISTS
EXISTS
Opt in all the rows that contains the specified field.
input | result |
|
|
|
GREATER_THAN
GREATER_THAN
Returns true
for instances where operand 1 is greater than operand 2.
operand 1 | operand 2 | result |
|
|
|
|
|
|
|
|
|
GREATER_THAN_OR_EQUAL_TO
GREATER_THAN_OR_EQUAL_TO
Returns true
for instances where operand 1 is greater than or equal to operand 2.
operand 1 | operand 2 | result |
|
|
|
|
|
|
|
|
|
IN_SET
IN_SET
Returns true
for instances where the value is contained in the given set.
Properties
Set - Values separated by line breaks
input | set | result |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
IS_DUPLICATE
IS_DUPLICATE
Returns true
if it's not the first time the input value is seen in the data within the specified window size.
This function creates a lookup table that holds all previous keys until the current run. During the current run, it uses in-memory caching to save all keys. A row returns true if the key exists in one of these two caches. However, because the in-memory cache does not work across shards, outputs with shards may contain duplicates that are not marked as such within the run (see workaround below).
Inputs
value - value to deduplicate
Properties
Dedup Id
Window Size - Deduplication window size in minutes
Workaround for shards
The following workaround removes duplicates from the same minute (the interval of the output) when using shards:
LESS_THAN
LESS_THAN
Returns true
for instances where operand 1 is less than operand .
operand 1 | operand 2 | result |
|
|
|
|
|
|
|
|
|
LESS_THAN_OR_EQUAL_TO
LESS_THAN_OR_EQUAL_TO
Returns true
for instances where operand 1 is less than or equal to operand 2.
operand 1 | operand 2 | result |
|
|
|
|
|
|
|
|
|
NOT
NOT
Returns true
if the value is false.
input | result |
|
|
|
|
NOT_EQUAL_TO
NOT_EQUAL_TO
Returns true
for instances where the operands are not equal.
operand 1 | operand 2 | result |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
OR
OR
Returns true
if at least one of the operands is true.
inputs | result |
|
|
|
|
|
|
|
|
RANDOM
RANDOM
Returns true
for a percentage of items equal to the input.
Inputs
percent - percentage (in decimal; e.g. 0.2, 0.5, etc) of items to mark as true
XOR
XOR
Returns true
only if the operands are different from each other.
operand 1 | operand 2 | result |
|
|
|
|
|
|
|
|
|
|
|
|
Last updated