Reactor

Operator Functions

Mappings: Functions and Expressions · Updated June 9, 2025

Concatenate

Description

  1. Concatenates arguments: either as strings or as arrays (depending on the type of the first argument).

Syntax

CONCAT(value1, value2, [...])

Examples

  1. CONCAT(1,2) returns 12

  2. CONCAT(source.order_no,"-",source.payment_status) returns the order number and payment status from a source, separated by a hyphen (-)

Equal

Description

  1. Returns TRUE if two specified values are equal and FALSE otherwise. This function is equivalent to the = operator.

Syntax

EQ(value1, value2)

Examples

  1. EQ(1,0) returns FALSE

  2. EQ(1,1) returns TRUE

Greater Than

Description

  1. Returns TRUE if the first argument is strictly greater than the second, and FALSE otherwise. This function is equivalent to the > operator.

Syntax

GT(value1, value2)

Examples

  1. GT(5,9) returns FALSE

  2. GT(9,5) returns TRUE

  3. GT(9,9) returns FALSE

Greater Than or Equal

Description

  1. Returns TRUE if the first argument is greater than or equal to the second, and FALSE otherwise. This function is equivalent to the >= operator.

Syntax

GTE(value1, value2)

Examples

  1. GTE(5,9) returns FALSE

  2. GTE(9,5) returns TRUE

  3. GTE(9,9) returns TRUE

Is Between

Description

  1. Checks whether a provided number is between two other numbers either inclusively or exclusively.

Syntax

ISBETWEEN(value, lower, upper, [lower_inclusive, upper_inclusive])

  1. lower_inclusive is optional, accepts booleans (1/0, TRUE/FALSE) and defaults to FALSE when not supplied

  2. upper_inclusive is optional, accepts booleans (1/0, TRUE/FALSE) and defaults to FALSE when not supplied

Examples

  1. ISBETWEEN(1,1,8) returns FALSE

  2. ISBETWEEN(1,1,8,true,true) returns TRUE

  3. ISBETWEEN(1,1,8,0,0) returns FALSE

  4. ISBETWEEN(8,1,8) returns FALSE

  5. ISBETWEEN(8,1,8,true,true) returns TRUE

Less Than

Description

  1. Returns TRUE if the first argument is strictly less than the second, and FALSE otherwise. This function is equivalent to the < operator.

Syntax

LT(value1, value2)

Examples

  1. LT(5,9) returns TRUE

  2. LT(9,5) returns FALSE

  3. LT(9,9) returns FALSE

Less Than or Equal

Description

  1. Returns TRUE if the first argument is less than or equal to the second, and FALSE otherwise. This function is equivalent to the <= operator.

Syntax

LTE(value1, value2)

Examples

  1. LTE(5,9) returns TRUE

  2. LTE(9,5) returns FALSE

  3. LTE(9,9) returns TRUE

Not Equal

Description

  1. Returns TRUE if two specified values are not equal and FALSE otherwise. This function is equivalent to the <> operator.

Syntax

NE(value1, value2)

Examples

  1. NE(1,0) returns FALSE

  2. NE(1,1) returns TRUE