ISNULL - Determining Whether an Object is Null

  • 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.

    iconNote:
    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

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

    Usage Position

    For details, see New Calculation Column.

    Example One

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

    3-1.png

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

    3-2.png

    Example Two - Displaying 0 When the Object Is Null

    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.

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

    4-1.png

    附件列表


    主题: Data Development - Scheduled Task
    Previous
    Next
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy