Skip to main content
Returns the first non-null value from a list of expressions. Evaluates expressions from left to right and returns the first one that is not null. If all expressions are null, returns null.
COALESCE function
Conditional function/statement that returns one value if a condition is true, and another value if false. Can be nested within other IFF functions for complex conditional logic. Syntax: IFF(condition, value_if_true, value_if_false).
The condition must default to a boolean value (true or false). That means that the statement ‘“hello”’ is not a boolean value. However, [column]=“hello” is a boolean value because it is either true or false for a given row.
If column function
Concatenates two or more string values into a single string with a custom separator/delimiter. Combines multiple text values in the order they are provided. Returns an empty string if all input values are null.
Concat function
Converts a value to a decimal column type. Handles conversion from strings, integers, and other numeric types.
Float function

Float function
Converts a value to an integer columns type. Rounds down to the nearest integer when converting from float values.
Int function
Converts a text literal or text column to a datetime type. Note that the value has to be without a time component and in this format: YYYY-MM-DD.
Date function
Converts a text literal or text column to a datetime type. Note that the value has to be with a time component and in this format: YYYY-MM-DD HH:MM:SS.
Datetime function
Logical operator that returns true only if all conditions are true. Typically used within IFF functions or IF Column tool for complex conditional logic. Returns false if any condition is false or null.
Each part of the AND function must default to a boolean value (true or false). That means that the statement ‘“hello”’ is not a boolean value. However, [column]=“hello” is a boolean value because it is either true or false for a given row.
AND function
Logical operator that returns true if at least one condition is true. Typically used within IFF functions or IF Column tool for complex conditional logic. Returns false only if all conditions are false or null.
Each part of the OR function must default to a boolean value (true or false). That means that the statement ‘“hello”’ is not a boolean value. However, [column]=“hello” is a boolean value because it is either true or false for a given row.
OR function
Returns a boolean value indicating whether a value is null. Returns true if the value is null, false otherwise. Useful for conditional logic and data validation.
ISNULL function
Returns a boolean value indicating whether a value is not null. Returns true if the value has any non-null content, false if the value is null. Useful for conditional logic and data validation.
ISNOTNULL function
Returns a boolean value indicating whether a value is true. Returns true if the value is true, false otherwise. Useful for conditional logic and data validation.
ISTRUE function
Returns a boolean value indicating whether a value is false. Returns true if the value is false, false otherwise. Useful for conditional logic and data validation.
ISFALSE function