QuestionQ78

Creating Field Aliases and Calculated Fields

Which function can serve as an alternative to coalesce for returning the first non-null value from a list of fields?

  • A bin
  • B case
  • C exact
  • D mvzip
Explanation

The case function evaluates conditions in sequence and returns the value associated with the first condition that is true. Testing each field for a non-null value in order therefore produces the first non-null field value, which is the behavior needed here.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!