Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

D code

derive type:single value: COALESCE([col1,col2,col3]) as: 'firstValue'

Output: Generates the firsValue firstValue column, which contains the first non-missing detected in col1col2, or col3 in that order. 

...