Reactor
Technical Guides

Reactor Function Library, Overview and Glossary

mmichi.huizinga2 min read
Reactor Function Library, Overview and Glossary

Below is a complete list of each function currently available in Reactor.

Table of Contents

  1. Types of Functions
    1. Date and Time Functions
    2. Logical Functions
    3. Math Functions
    4. Operator Functions
    5. Statistic Functions
    6. Structure Functions
    7. Text Functions
  2. Glossary

Types of Functions

  1. Date and Time Functions
  2. Logical Functions
  3. Math Functions
  4. Operator Functions
  5. Statistic Functions
  6. Structure Functions
  7. Text Functions

Glossary

Date, Time, Timezone

  • date: A Gregorian calendar date (range: 0001-01-01 to 9999-12-31), independent of time zone.
  • datetime: A Gregorian date and a time (range: 0001-01-01 00:00:00 to 9999-12-31 23:59:59.999999), as they might be displayed on a watch, independent of time zone. It includes the year, month, day, hour, minute, second, and subsecond. To represent an absolute point in time, use a timestamp.
  • day: The day component of a date, datetime, or timestamp.
  • hour: The hour component of a datetime or timestamp
  • microsecond: The microsecond component of a datetime or timestamp
  • minute: The minute component of a datetime or timestamp.
  • month: The month component of a date, datetime, or timestamp.
  • second: The second component of a datetime or timestamp
  • timestamp: an absolute point in time (range: 0001-01-01 00:00:00 UTC to 9999-12-31 23:59:59.999999 UTC), independent of any time zone or convention such as daylight saving time (DST), with microsecond precision.
  • timezone: A string that represents a timezone or UTC offset. For a reference of timezone strings, see the List of tz database time zones article on Wikipedia.
  • year: The year component of a date, datetime, or timestamp.

Lambda Helper Function

A Lambda Helper function is a native function which accepts a reusable Lambda function as an argument along with one or more other inputs. Alternatively, the Lambda function could be written as an expression with the name each as follows:

1 each

This is useful when calling all instances of a repeated attribute in source data. Typically, the each will be referenced in a Lambda Helper Function that supplies more information regarding the variable.

Lambda functions include:

  • Apply
  • Filter
  • Flatmap
  • List
  • Map

Operators

In addition to the Math Functions and Operator Functions listed on this page, a full list of supported operators is below:

Operator Description
, Separates two terms in a list, function, pair
|| Logical or
&& Logical and
== != Equality/inequality operators
< > <= >= Comparison operators
- + Add and subtract
% ^ Modulo and power
/ * Multiple/divide
! Negate
( ) Grouping

Ready when you are

Ready to put your data to work?

Talk to the Reactor team about your data goals.

Contact us