AND
true
if all operands are true.false
, false
false
false
, true
false
true
, false
false
true
, true
true
BETWEEN
CONTAINS
true
for instances where the left operand contains the right operand."abcde"
"a"
true
"abcde"
"f"
false
EQUAL_TO
0
0
true
1
0
false
0
1
false
"a"
"a"
true
"a"
"b"
false
EXISTS
"a"
true
false
GREATER_THAN
true
for instances where operand 1 is greater than operand 2.0
0
false
1
0
true
0
1
false
GREATER_THAN_OR_EQUAL_TO
true
for instances where operand 1 is greater than or equal to operand 2.0
0
true
1
0
true
0
1
false
IN_SET
true
for instances where the value is contained in the given set."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
true
if it's not the first time the input value is seen in the data within the specified window size.LESS_THAN
true
for instances where operand 1 is less than operand .0
0
false
1
0
false
0
1
true
LESS_THAN_OR_EQUAL_TO
true
for instances where operand 1 is less than or equal to operand 2.0
0
true
1
0
false
0
1
true
NOT
true
if the value is false.true
false
false
true
NOT_EQUAL_TO
true
for instances where the operands are not equal.0
0
false
1
0
true
0
1
true
"a"
"a"
false
"a"
"b"
true
OR
true
if at least one of the operands is true.false
, false
false
false
, true
true
true
, false
true
true
, true
true
RANDOM
true
for a percentage of items equal to the input.XOR
true
only if the operands are different from each other.false
false
false
false
true
true
true
false
true
true
true
false