cancel
Showing results for 
Search instead for 
Did you mean: 
With our short, effective, relevant, and interactive lessons that include videos, activities, and quizzes, you'll be up and running in no time!
Interactive Lessons
With our short, effective, relevant, and interactive lessons that include videos, activities, and quizzes, you'll be up and running in no time!
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Evaluating Null and Empty Values

Sr. Instructional Designer
Sr. Instructional Designer

Lesson Objective: Leverage Null and Empty values in your data in your expressions.

Estimated Time: ~5 Minutes

Description:

  • Understand how Null and empty values are represented as values in data
  • Learn the proper syntax for testing Null values in a dataset and replacing values with Null.
  • Assess empty values in expressions.
  • Test your understanding with a quiz!

Recommended Follow-Up: Writing Conditional Statements, Preparing Data with String Functions

Comments
Asteroid

The end of the last video left me hanging. How can you quickly evaluate a cell that only has non-visible characters (space, tab, carriage return)?