ISBLANK

ISBLANK(value)[source]

Returns True if the input value is blank, otherwise False.

This function checks whether value is blank (empty or NULL). It evaluates to a boolean formula, making it useful for conditional logic and null-checking within models. Both singular values and arrays are supported.

Parameters:

value (Operand) – The value to check if blank.

Return type:

Formula

Returns:

True if value is blank, False otherwise. Returns an array of boolean values if value is an array.

Examples

ISBLANK(customer["email"])
# Returns True if email is blank, else False

``value`` — accepted types

  • BOOLEAN

  • BOOLEAN_ARRAY

  • BOOLEAN_MAP

  • DATE

  • DATETIME

  • DATETIME_ARRAY

  • DATETIME_MAP

  • DATE_ARRAY

  • DATE_MAP

  • DECIMAL

  • DECIMAL_ARRAY

  • DECIMAL_MAP

  • INTEGER

  • INTEGER_ARRAY

  • INTEGER_MAP

  • NULL

  • OBJECT

  • OBJECT_ARRAY

  • STRING

  • STRING_ARRAY

  • STRING_MAP

  • TIME

  • TIME_ARRAY

  • TIME_MAP

Return types

  • BOOLEAN