ISNULL - Determining Whether an Object is Null- FineDataLink Help Document

Last update: May 21, 2025

Overview

Syntax	ISNULL(Parameter)	Judges whether the value of the object is NULL.Returns TRUE if the value is NULL. Otherwise, returns FALSE. Note: This function only supports single parameter judgement.
Parameter 1	Parameter	Object to be judged. If the value is NULL, the function returns TRUE. Otherwise, the function returns FALSE.
Return Value Type	Boolean

Syntax

ISNULL(Parameter)

Judges whether the value of the object is NULL.Returns TRUE if the value is NULL. Otherwise, returns FALSE.

Note:

This function only supports single parameter judgement.

Parameter 1

Parameter

Object to be judged. If the value is NULL, the function returns TRUE. Otherwise, the function returns FALSE.

Return Value Type

Boolean

Note:

To assign values to null data, you can use the NVL() function in SparkSQL.

If the value of Owner_City is null, the function returns true. Otherwise, the function returns false, as shown in the following figure.

The result of the added column is shown in the following figure.

Scenario: If the field value is null, 0 is returned by default.

Use the formula IF(ISNULL(Employee_ID,"0",Employee_ID), as shown in the following figure.

Note:

The Employee_ID field needs to be manually selected from the field list on the right side of the function list.

Previous：IF

中文（简体）

English