ISBLANK function

This topic describes the formula syntax and usage of the ISBLANK function in the Data Quality Execute Formula transform.

Description

Returns TRUE if the value is blank.

Syntax

ISBLANK(value)

The ISBLANK function syntax has the following argument:

  • value Required. The value that you want tested. The value argument can be a blank (empty field), error, logical value, text, number, or reference value, or a column reference referring to any of these.

Note

  • This function returns 1 for true or 0 for false. These show as true or false in a Boolean field.
  • The ISBLANK function is useful to test the contents of a field or the outcome of a calculation.

Example

Formula OpenDate Result (Boolean field) Result (Integer field)
ISBLANK([OpenDate]) 2020-06-06 OpenDate field has content. false 0
ISBLANK([OpenDate]) OpenDate field is empty. true 1