Upsolver
Search…
Filter functions
This page goes over the filter functions in Upsolver.

AND

Returns true if all operands are true.
inputs
result
false, false
false
false, true
false
true, false
false
true, true
true

BETWEEN

Checks if a value is between two values.

Inputs

  • value
  • lowerBound
  • upperBound

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.
operand 1
operand 2
result
0
0
true
1
0
false
0
1
false
"a"
"a"
true
"a"
"b"
false

EXISTS

Opt in all the rows that contains the specified field.
input
result
"a"
true
false

GREATER_THAN

Returns true for instances where operand 1 is greater than operand 2.
operand 1
operand 2
result
0
0
false
1
0
true
0
1
false

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
0
0
true
1
0
true
0
1
false

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
"a"
"a b"
true
"c"
"a b"
false
1
"1 2 3.14"
true
2
"1 2 3.14"
true
3
"1 2 3.14"
false
3.14
"1 2 3.14"
true

IS_DUPLICATE

Returns true if it's not the first time the input value is seen in the data within the specified window size.

Inputs

  • value - value to deduplicate

Properties

  • Dedup Id
  • Window Size - Deduplication window size in minutes

LESS_THAN

Returns true for instances where operand 1 is less than operand .
operand 1
operand 2
result
0
0
false
1
0
false
0
1
true

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
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.
operand 1
operand 2
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 - percentage (in decimal; e.g. 0.2, 0.5, etc) of items to mark as true

XOR

Returns true only if the operands are different from each other.
operand 1
operand 2
result
false
false
false
false
true
true
true
false
true
true
true
false