Support | Blog | Contact Us
changes.mady.by.user docuser1
Saved on Feb 06, 2018
Saved on Nov 06, 2018
...
derive type:single value: COALESCE([col1,col2,col3]) as: 'firstValue'
Output: Generates the firsValue firstValue column, which contains the first non-missing detected in col1, col2, or col3 in that order.
firsValue
firstValue
col1
col2
col3