Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

  • The NULL function generates null values. See NULL Function.
  • The ISNULL function simply tests if a value is null. See ISNULL Function.
  • Null values are different from missing values. 
  • For more information on null values, see Manage Null Values.

D s
snippetBasic

...

IFNULL
d-codelang-syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:
ifnull(my_score,'0') as:'final_score'

...

ifnull(my_score,

...

'0')

Output: Returns the value 0 if the value in my_score is a null. 

D s
snippetSyntax

IFNULL
d-codelang-syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:
ifnull(column_string, computed_value)

ifnull(column_string, computed_value)

...