Filters Functions

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 number is between two numbers

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

Inputs

first
second
first second 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 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
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

True if it's not the first time we see the input value in the data in 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 the left operand is less than the right operand

Inputs

first
second
firstsecondresult
00false
10false
01true

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
firstsecondresult
00true
10false
01true

NOT

Returns true if the value is false

inputresult
truefalse
falsetrue

NOT_EQUAL_TO

Returns true for instances where the operands are not equal

Inputs

first
second
firstsecondresult
00false
10true
01true
"a""a"false
"a""b"true

OR

Returns true if at least one of the operands is true

inputsresult
false, falsefalse
false, truetrue
true, falsetrue
true, truetrue
RANDOM

RANDOM

Returns true for a percentage of items equal to the input

Inputs

percent - percent of items to keep
 

XOR

Returns true if both operands are not equal

Inputs

left
right
leftrightresult
falsefalsefalse
falsetruetrue
truefalsetrue
truetruefalse