Operation

These blocks operate on values in the same row. They are usually used with value blocks inside transformation blocks.

Arithmetic

Arithmetic

This block implements mathematical computations on two values. It accepts numbers, column names, and nested operation blocks.

Comparison

Comparison

This block compares two values, producing true or false as a result. It accepts numbers, text, column names, and nested operation blocks.

Type conversion

Type conversion

Convert a value from one type to another.

Date/time conversion

Date/time conversion

Extract the year, month, or day from a date/time value.

If/else

If/else

Select one of two values based on a condition. Any value can be used for the condition or for the results if the condition is true or false, but the values used for the true and false cases must have the same type.

Logical AND/OR

Logical AND/OR

This block implements logical operations on two values. It accepts any values on the left and right side and produces either true or false.

Note that logical AND is only true if both sides are true, while logical OR is true if either or both sides are true: it is not either-or-both rather than one-or-the-other.

Negation

Negation

Negate a number.

Logical NOT

Logical NOT

Produce true if the value is false or false if the value is true.

Type check

Type check

Check if a value is of a particular type.